{smcl}
{com}{sf}{ul off}{txt}{.-}
      name:  {res}<unnamed>
       {txt}log:  {res}R:\WSV2\TBu_AKe\Bunching_NEW\Data\bunching_1_bins_2703.smcl
  {txt}log type:  {res}smcl
 {txt}opened on:  {res}11 Apr 2023, 18:04:28
{txt}
{com}. 
. cd
{res}R:\WSV2\TBu_AKe\Bunching_NEW\Data
{txt}
{com}. 
.         ** Load data ** 
. use "R:\WSV2\TBu_AKe\Product Ban\Stata\Bunching_Empirics\WM_V10_precollapse_binbasis.dta"
{txt}
{com}.  
. gen kwh = ae // avoid confusion with E,e : yearly consumption as defined by regulation.  
{txt}(689,472 missing values generated)

{com}. 
.         
.         ** Determine width and steps of spatial cells ***
.  
.         * a (capacity)
. scalar int_a = 0.5 // steps
{txt}
{com}. scalar low_a = 2.75 // minimum
{txt}
{com}. scalar high_a = 15.25 // max 
{txt}
{com}.         * eei 
. scalar int_e = 0.5 // steps
{txt}
{com}. scalar low_e = 13 // minimum
{txt}
{com}. scalar high_e = 143 
{txt}
{com}. 
. 
. ***************************************
. ** Step 1: cut cells to grid 
. ***************************************
. 
.         * 1a: capacity a 
. egen a_bin=cut(capacity),at(`=low_a'(0.5)`=high_a')
{txt}(4,895 missing values generated)

{com}. replace a_bin = a_bin + (`=int_a'/2) // name by midpoint.
{txt}(1,184,678 real changes made)

{com}.         ** bin labelled 4.25 is technically (4.251 to 4.749), after rename by midpoint: 4.5 is (4.251 to 4.749)
. 
. sum a_bin 

{txt}    Variable {c |}        Obs        Mean    Std. dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 7}a_bin {c |}{res}  1,184,678     6.02591    1.255609          3         15
{txt}
{com}. codebook a_bin 

{txt}{hline}
{res}a_bin{right:(unlabeled)}
{txt}{hline}

{col 19}Type: Numeric ({res}float{txt})

{col 18}Range: [{res}3{txt},{res}15{txt}]{col 55}Units: {res}.1
{col 10}{txt}Unique values: {res}21{col 51}{txt}Missing .: {res}4,895{txt}/{res}1,189,573

{txt}{col 19}Mean: {res}{ralign 7:6.02591}
{txt}{col 14}Std. dev.: {res}{ralign 7:1.25561}

{txt}{col 12}Percentiles: {col 25}{ralign 7:10%}{ralign 10:25%}{ralign 10:50%}{ralign 10:75%}{ralign 10:90%}
{res}{col 25}{ralign 7:5}{ralign 10:       5}{ralign 10:       6}{ralign 10:       7}{ralign 10:       8}
{txt}
{com}.         * result: 18 cells of width 0.5 
.  
.         * 1b: e (in kwh/year) as defined by the eei 
.             * note: energy consumption e in a cell is determined by a and eei
. codebook eei_bin // 133 unique values  

{txt}{hline}
{res}eei_bin{right:(unlabeled)}
{txt}{hline}

{col 19}Type: Numeric ({res}float{txt})

{col 18}Range: [{res}13.5{txt},{res}271{txt}]{col 55}Units: {res}.1
{col 10}{txt}Unique values: {res}134{col 51}{txt}Missing .: {res}689,472{txt}/{res}1,189,573

{txt}{col 19}Mean: {res}{ralign 7:50.1225}
{txt}{col 14}Std. dev.: {res}{ralign 7:10.58}

{txt}{col 12}Percentiles: {col 25}{ralign 7:10%}{ralign 10:25%}{ralign 10:50%}{ralign 10:75%}{ralign 10:90%}
{res}{col 25}{ralign 7:38.5}{ralign 10:    44.5}{ralign 10:    50.5}{ralign 10:    57.5}{ralign 10:      61}
{txt}
{com}. label variable eei_bin "EEI in 0.5-unit bins"
{txt}
{com}. 
. gen e_max = 0 
{txt}
{com}. 
. sort eei_bin 
{txt}
{com}. forvalues i=`=low_e'(1)`=high_e' {c -(}
{txt}  2{com}.  quietly sum kwh if eei_bin == `i' 
{txt}  3{com}.  local k = r(max)
{txt}  4{com}.  replace e_max = `k' if eei_bin==`i' // determine max energy consumption allowed for a given size and eei value 
{txt}  5{com}. {c )-}
{txt}(0 real changes made)
(0 real changes made)
(0 real changes made)
(1 real change made)
(0 real changes made)
(177 real changes made)
(13 real changes made)
(0 real changes made)
(0 real changes made)
(1,033 real changes made)
(0 real changes made)
(0 real changes made)
(99 real changes made)
(50 real changes made)
(3,329 real changes made)
(73 real changes made)
(36 real changes made)
(0 real changes made)
(0 real changes made)
(16,062 real changes made)
(416 real changes made)
(0 real changes made)
(561 real changes made)
(5,864 real changes made)
(432 real changes made)
(2,837 real changes made)
(1,560 real changes made)
(916 real changes made)
(9,070 real changes made)
(8,763 real changes made)
(10,427 real changes made)
(21,741 real changes made)
(18,579 real changes made)
(1,494 real changes made)
(1,849 real changes made)
(1,873 real changes made)
(10,827 real changes made)
(7,345 real changes made)
(8,375 real changes made)
(6,680 real changes made)
(1,755 real changes made)
(1,205 real changes made)
(11,874 real changes made)
(5,468 real changes made)
(5,348 real changes made)
(20,314 real changes made)
(10,158 real changes made)
(732 real changes made)
(10,082 real changes made)
(396 real changes made)
(745 real changes made)
(577 real changes made)
(3,102 real changes made)
(5,463 real changes made)
(3,254 real changes made)
(4,574 real changes made)
(216 real changes made)
(60 real changes made)
(444 real changes made)
(240 real changes made)
(85 real changes made)
(0 real changes made)
(673 real changes made)
(156 real changes made)
(205 real changes made)
(156 real changes made)
(96 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(156 real changes made)
(61 real changes made)
(0 real changes made)
(0 real changes made)
(264 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(13 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(652 real changes made)
(0 real changes made)
(132 real changes made)
(0 real changes made)
(0 real changes made)
(216 real changes made)
(0 real changes made)
(0 real changes made)
(144 real changes made)
(0 real changes made)
(0 real changes made)
(769 real changes made)
(0 real changes made)
(0 real changes made)
(180 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(84 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(96 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(12 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(48 real changes made)

{com}. 
. sum a_bin eei_bin // summarize bin structure  

{txt}    Variable {c |}        Obs        Mean    Std. dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 7}a_bin {c |}{res}  1,184,678     6.02591    1.255609          3         15
{txt}{space 5}eei_bin {c |}{res}    500,101    50.12246    10.57997       13.5        271
{txt}
{com}. 
. 
.         * 1c: store cell borders in local macros and scalars ***
. sum a_bin, meanonly
{txt}
{com}. scalar max_a = `r(max)' 
{txt}
{com}. scalar min_a = `r(min)'
{txt}
{com}.         ** number of steps 
. scalar n_a = 1+ (`=max_a' - `=min_a')/0.5
{txt}
{com}. 
. *** e_bin based on eei 
. sum eei_bin, meanonly
{txt}
{com}. scalar max_eei = `r(max)'       
{txt}
{com}. scalar min_eei = `r(min)'
{txt}
{com}. scalar int_eei = 0.5
{txt}
{com}.         ** number of steps 
. scalar n_e = 1+ (`=max_eei' - `=min_eei')/`=int_eei'
{txt}
{com}. 
. scalar list // n_e: 260, n_a: 25. 
{txt}       n_e = {res}       516
{txt}   int_eei = {res}        .5
{txt}   min_eei = {res}      13.5
{txt}   max_eei = {res}       271
{txt}       n_a = {res}        25
{txt}     min_a = {res}         3
{txt}     max_a = {res}        15
{txt}    high_e = {res}       143
{txt}     low_e = {res}        13
{txt}     int_e = {res}        .5
{txt}    high_a = {res}     15.25
{txt}     low_a = {res}      2.75
{txt}     int_a = {res}        .5
{txt}
{com}. 
. 
.                 ****************************
.                 *** 1d: create full grid *** 
.                 ****************************
. 
. sort a_bin // capacity at bin-level 
{txt}
{com}. 
. gen ts = .                       // temporary cell identifier
{txt}(1,189,573 missing values generated)

{com}. gen added_a = 0         // to identify added observations in later checks 
{txt}
{com}. 
. sum a_bin, meanonly
{txt}
{com}.         *** 0.5 is cell width, smallest bin starts at 2.5 kg    
. forvalues i=`=min_a'(0.5)`=max_a' {c -(}
{txt}  2{com}. replace ts= (2*(`i') - 5) if a_bin==`i' 
{txt}  3{com}.         * example: 2*3 - 5 = 1 for smallest
. {c )-}
{txt}(6,522 real changes made)
(12,523 real changes made)
(15,425 real changes made)
(58,514 real changes made)
(348,711 real changes made)
(57,248 real changes made)
(312,960 real changes made)
(6,248 real changes made)
(214,578 real changes made)
(4,404 real changes made)
(111,118 real changes made)
(216 real changes made)
(22,849 real changes made)
(0 real changes made)
(7,758 real changes made)
(156 real changes made)
(3,017 real changes made)
(204 real changes made)
(1,942 real changes made)
(0 real changes made)
(126 real changes made)
(0 real changes made)
(12 real changes made)
(0 real changes made)
(147 real changes made)

{com}. 
. 
. replace ts = 1 if ts == .      // fix missings 
{txt}(4,895 real changes made)

{com}. by ts, sort: gen panel_a=_n   // running list of all values 
{txt}
{com}. tsset panel_a ts             // set:1 to 25 with gaps 
{res}
{col 1}{txt:Panel variable: }{res:panel_a}{txt: (unbalanced)}
{p 1 16 2}{txt:Time variable: }{res:ts}{txt:, }{res:{bind:1}}{txt: to }{res:{bind:25}}{txt:, but with gaps}{p_end}
{txt}{col 10}Delta: {res}1 unit
{txt}
{com}. tsfill                      // fill 
{txt}
{com}. tab ts                     // confirm that there are no gaps 

         {txt}ts {c |}      Freq.     Percent        Cum.
{hline 12}{c +}{hline 35}
          1 {c |}{res}     11,417        0.64        0.64
{txt}          2 {c |}{res}     12,523        0.70        1.33
{txt}          3 {c |}{res}     15,425        0.86        2.19
{txt}          4 {c |}{res}     58,514        3.26        5.45
{txt}          5 {c |}{res}    348,711       19.42       24.87
{txt}          6 {c |}{res}    312,960       17.43       42.29
{txt}          7 {c |}{res}    312,960       17.43       59.72
{txt}          8 {c |}{res}    214,578       11.95       71.67
{txt}          9 {c |}{res}    214,578       11.95       83.62
{txt}         10 {c |}{res}    111,118        6.19       89.80
{txt}         11 {c |}{res}    111,118        6.19       95.99
{txt}         12 {c |}{res}     22,849        1.27       97.26
{txt}         13 {c |}{res}     22,849        1.27       98.53
{txt}         14 {c |}{res}      7,758        0.43       98.97
{txt}         15 {c |}{res}      7,758        0.43       99.40
{txt}         16 {c |}{res}      3,017        0.17       99.57
{txt}         17 {c |}{res}      3,017        0.17       99.73
{txt}         18 {c |}{res}      1,942        0.11       99.84
{txt}         19 {c |}{res}      1,942        0.11       99.95
{txt}         20 {c |}{res}        147        0.01       99.96
{txt}         21 {c |}{res}        147        0.01       99.97
{txt}         22 {c |}{res}        147        0.01       99.98
{txt}         23 {c |}{res}        147        0.01       99.98
{txt}         24 {c |}{res}        147        0.01       99.99
{txt}         25 {c |}{res}        147        0.01      100.00
{txt}{hline 12}{c +}{hline 35}
      Total {c |}{res}  1,795,916      100.00
{txt}
{com}. 
. by ts, sort: replace panel_a=_n
{txt}(1,795,900 real changes made)

{com}. replace added_a = 1 if added_a == .     // identifies added observations when == 1 
{txt}(606,343 real changes made)

{com}. drop if panel_a > 1 & added_a == 1     // reduce to only 1 observations per added cell 
{txt}(606,332 observations deleted)

{com}. 
. 
. gen a_binf = 0 
{txt}
{com}. summ ts, meanonly                                       // only integers, continuous list 
{txt}
{com}. forvalues i=`=r(min)'(1)`=r(max)' {c -(}
{txt}  2{com}. replace a_binf= (0.5*(`i') + 2.5) if ts==`i' //  0.5 is step width, 2.5 is minimum.
{txt}  3{com}. {c )-}
{txt}(11,417 real changes made)
(12,523 real changes made)
(15,425 real changes made)
(58,514 real changes made)
(348,711 real changes made)
(57,249 real changes made)
(312,960 real changes made)
(6,249 real changes made)
(214,578 real changes made)
(4,405 real changes made)
(111,118 real changes made)
(217 real changes made)
(22,849 real changes made)
(1 real change made)
(7,758 real changes made)
(157 real changes made)
(3,017 real changes made)
(205 real changes made)
(1,942 real changes made)
(1 real change made)
(126 real changes made)
(1 real change made)
(13 real changes made)
(1 real change made)
(147 real changes made)

{com}. 
. tab a_binf      // must be balanced: 3 to 15, at 0.5 steps.  

     {txt}a_binf {c |}      Freq.     Percent        Cum.
{hline 12}{c +}{hline 35}
          3 {c |}{res}     11,417        0.96        0.96
{txt}        3.5 {c |}{res}     12,523        1.05        2.01
{txt}          4 {c |}{res}     15,425        1.30        3.31
{txt}        4.5 {c |}{res}     58,514        4.92        8.23
{txt}          5 {c |}{res}    348,711       29.31       37.54
{txt}        5.5 {c |}{res}     57,249        4.81       42.35
{txt}          6 {c |}{res}    312,960       26.31       68.66
{txt}        6.5 {c |}{res}      6,249        0.53       69.19
{txt}          7 {c |}{res}    214,578       18.04       87.23
{txt}        7.5 {c |}{res}      4,405        0.37       87.60
{txt}          8 {c |}{res}    111,118        9.34       96.94
{txt}        8.5 {c |}{res}        217        0.02       96.96
{txt}          9 {c |}{res}     22,849        1.92       98.88
{txt}        9.5 {c |}{res}          1        0.00       98.88
{txt}         10 {c |}{res}      7,758        0.65       99.53
{txt}       10.5 {c |}{res}        157        0.01       99.54
{txt}         11 {c |}{res}      3,017        0.25       99.80
{txt}       11.5 {c |}{res}        205        0.02       99.81
{txt}         12 {c |}{res}      1,942        0.16       99.98
{txt}       12.5 {c |}{res}          1        0.00       99.98
{txt}         13 {c |}{res}        126        0.01       99.99
{txt}       13.5 {c |}{res}          1        0.00       99.99
{txt}         14 {c |}{res}         13        0.00       99.99
{txt}       14.5 {c |}{res}          1        0.00       99.99
{txt}         15 {c |}{res}        147        0.01      100.00
{txt}{hline 12}{c +}{hline 35}
      Total {c |}{res}  1,189,584      100.00
{txt}
{com}. 
. replace a_bin = a_binf if added_a == 1  // re-assign for newly added cells.
{txt}(11 real changes made)

{com}.  
. tab a_bin       // must be balanced: 3 to 15, at 0.5 steps.

      {txt}a_bin {c |}      Freq.     Percent        Cum.
{hline 12}{c +}{hline 35}
          3 {c |}{res}      6,522        0.55        0.55
{txt}        3.5 {c |}{res}     12,523        1.06        1.61
{txt}          4 {c |}{res}     15,425        1.30        2.91
{txt}        4.5 {c |}{res}     58,514        4.94        7.85
{txt}          5 {c |}{res}    348,711       29.43       37.28
{txt}        5.5 {c |}{res}     57,249        4.83       42.12
{txt}          6 {c |}{res}    312,960       26.42       68.53
{txt}        6.5 {c |}{res}      6,249        0.53       69.06
{txt}          7 {c |}{res}    214,578       18.11       87.17
{txt}        7.5 {c |}{res}      4,405        0.37       87.55
{txt}          8 {c |}{res}    111,118        9.38       96.92
{txt}        8.5 {c |}{res}        217        0.02       96.94
{txt}          9 {c |}{res}     22,849        1.93       98.87
{txt}        9.5 {c |}{res}          1        0.00       98.87
{txt}         10 {c |}{res}      7,758        0.65       99.53
{txt}       10.5 {c |}{res}        157        0.01       99.54
{txt}         11 {c |}{res}      3,017        0.25       99.79
{txt}       11.5 {c |}{res}        205        0.02       99.81
{txt}         12 {c |}{res}      1,942        0.16       99.98
{txt}       12.5 {c |}{res}          1        0.00       99.98
{txt}         13 {c |}{res}        126        0.01       99.99
{txt}       13.5 {c |}{res}          1        0.00       99.99
{txt}         14 {c |}{res}         13        0.00       99.99
{txt}       14.5 {c |}{res}          1        0.00       99.99
{txt}         15 {c |}{res}        147        0.01      100.00
{txt}{hline 12}{c +}{hline 35}
      Total {c |}{res}  1,184,689      100.00
{txt}
{com}. 
. drop ts a_binf // drop auxiliary variables  
{txt}
{com}. 
. 
. sort eei_bin // eei at bin level 
{txt}
{com}. 
. gen ts = . // temporary cell identifier
{txt}(1,189,584 missing values generated)

{com}. gen added_eei = 0  // identifier for added cells 
{txt}
{com}. 
. sum eei_bin, meanonly
{txt}
{com}.         *** 0.5 is step width, 13.5 is min value in eei 
. forvalues i=`=min_eei'(0.5)`=max_eei' {c -(} 
{txt}  2{com}.         replace ts= (2*(`i') - 26) if eei_bin==`i' 
{txt}  3{com}. {c )-}
{txt}(164 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(1 real change made)
(0 real changes made)
(0 real changes made)
(63 real changes made)
(177 real changes made)
(0 real changes made)
(13 real changes made)
(0 real changes made)
(0 real changes made)
(518 real changes made)
(0 real changes made)
(0 real changes made)
(1,033 real changes made)
(1,477 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(99 real changes made)
(0 real changes made)
(50 real changes made)
(315 real changes made)
(3,329 real changes made)
(329 real changes made)
(73 real changes made)
(84 real changes made)
(36 real changes made)
(1,015 real changes made)
(0 real changes made)
(26 real changes made)
(0 real changes made)
(3,596 real changes made)
(16,062 real changes made)
(616 real changes made)
(416 real changes made)
(108 real changes made)
(0 real changes made)
(132 real changes made)
(561 real changes made)
(733 real changes made)
(5,864 real changes made)
(5,963 real changes made)
(432 real changes made)
(1,415 real changes made)
(2,837 real changes made)
(2,594 real changes made)
(1,560 real changes made)
(4,116 real changes made)
(916 real changes made)
(2,747 real changes made)
(9,070 real changes made)
(1,729 real changes made)
(8,763 real changes made)
(5,027 real changes made)
(10,427 real changes made)
(7,643 real changes made)
(21,741 real changes made)
(24,172 real changes made)
(18,579 real changes made)
(51,072 real changes made)
(1,494 real changes made)
(2,257 real changes made)
(1,849 real changes made)
(1,922 real changes made)
(1,873 real changes made)
(2,359 real changes made)
(10,827 real changes made)
(2,241 real changes made)
(7,345 real changes made)
(24,178 real changes made)
(8,375 real changes made)
(32,455 real changes made)
(6,680 real changes made)
(655 real changes made)
(1,755 real changes made)
(3,023 real changes made)
(1,205 real changes made)
(3,121 real changes made)
(11,874 real changes made)
(3,883 real changes made)
(5,468 real changes made)
(9,162 real changes made)
(5,348 real changes made)
(14,117 real changes made)
(20,314 real changes made)
(29,394 real changes made)
(10,158 real changes made)
(3,278 real changes made)
(732 real changes made)
(1,620 real changes made)
(10,082 real changes made)
(852 real changes made)
(396 real changes made)
(6,064 real changes made)
(745 real changes made)
(2,450 real changes made)
(577 real changes made)
(745 real changes made)
(3,102 real changes made)
(636 real changes made)
(5,463 real changes made)
(0 real changes made)
(3,254 real changes made)
(2,339 real changes made)
(4,574 real changes made)
(984 real changes made)
(216 real changes made)
(1,260 real changes made)
(60 real changes made)
(276 real changes made)
(444 real changes made)
(481 real changes made)
(240 real changes made)
(1,620 real changes made)
(85 real changes made)
(432 real changes made)
(0 real changes made)
(240 real changes made)
(673 real changes made)
(84 real changes made)
(156 real changes made)
(576 real changes made)
(205 real changes made)
(0 real changes made)
(156 real changes made)
(84 real changes made)
(96 real changes made)
(156 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(12 real changes made)
(0 real changes made)
(0 real changes made)
(156 real changes made)
(0 real changes made)
(61 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(120 real changes made)
(264 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(96 real changes made)
(0 real changes made)
(36 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(13 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(24 real changes made)
(652 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(132 real changes made)
(0 real changes made)
(0 real changes made)
(144 real changes made)
(0 real changes made)
(0 real changes made)
(216 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(144 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(769 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(180 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(216 real changes made)
(0 real changes made)
(0 real changes made)
(84 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(132 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(96 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(12 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(48 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(36 real changes made)

{com}. 
. replace ts = 1 if ts == .                        // fix missings 
{txt}(689,483 real changes made)

{com}. by ts, sort: gen panel_e=_n             //  running list of all values
{txt}
{com}. tsset panel_e ts                                   // set to unbalanced panel 
{res}
{col 1}{txt:Panel variable: }{res:panel_e}{txt: (unbalanced)}
{p 1 16 2}{txt:Time variable: }{res:ts}{txt:, }{res:{bind:1}}{txt: to }{res:{bind:516}}{txt:, but with gaps}{p_end}
{txt}{col 10}Delta: {res}1 unit
{txt}
{com}. tsfill                            // fill 
{txt}
{com}. tab ts                                                   // 1-260 w/o gaps. 

         {txt}ts {c |}      Freq.     Percent        Cum.
{hline 12}{c +}{hline 35}
          1 {c |}{res}    689,647       13.86       13.86
{txt}          2 {c |}{res}     51,072        1.03       14.89
{txt}          3 {c |}{res}     51,072        1.03       15.92
{txt}          4 {c |}{res}     51,072        1.03       16.94
{txt}          5 {c |}{res}     51,072        1.03       17.97
{txt}          6 {c |}{res}     51,072        1.03       19.00
{txt}          7 {c |}{res}     51,072        1.03       20.02
{txt}          8 {c |}{res}     51,072        1.03       21.05
{txt}          9 {c |}{res}     51,072        1.03       22.08
{txt}         10 {c |}{res}     51,072        1.03       23.10
{txt}         11 {c |}{res}     51,072        1.03       24.13
{txt}         12 {c |}{res}     51,072        1.03       25.16
{txt}         13 {c |}{res}     51,072        1.03       26.18
{txt}         14 {c |}{res}     51,072        1.03       27.21
{txt}         15 {c |}{res}     51,072        1.03       28.24
{txt}         16 {c |}{res}     51,072        1.03       29.26
{txt}         17 {c |}{res}     51,072        1.03       30.29
{txt}         18 {c |}{res}     51,072        1.03       31.32
{txt}         19 {c |}{res}     51,072        1.03       32.34
{txt}         20 {c |}{res}     51,072        1.03       33.37
{txt}         21 {c |}{res}     51,072        1.03       34.40
{txt}         22 {c |}{res}     51,072        1.03       35.42
{txt}         23 {c |}{res}     51,072        1.03       36.45
{txt}         24 {c |}{res}     51,072        1.03       37.48
{txt}         25 {c |}{res}     51,072        1.03       38.50
{txt}         26 {c |}{res}     51,072        1.03       39.53
{txt}         27 {c |}{res}     51,072        1.03       40.56
{txt}         28 {c |}{res}     51,072        1.03       41.58
{txt}         29 {c |}{res}     51,072        1.03       42.61
{txt}         30 {c |}{res}     51,072        1.03       43.64
{txt}         31 {c |}{res}     51,072        1.03       44.66
{txt}         32 {c |}{res}     51,072        1.03       45.69
{txt}         33 {c |}{res}     51,072        1.03       46.72
{txt}         34 {c |}{res}     51,072        1.03       47.74
{txt}         35 {c |}{res}     51,072        1.03       48.77
{txt}         36 {c |}{res}     51,072        1.03       49.80
{txt}         37 {c |}{res}     51,072        1.03       50.82
{txt}         38 {c |}{res}     51,072        1.03       51.85
{txt}         39 {c |}{res}     51,072        1.03       52.88
{txt}         40 {c |}{res}     51,072        1.03       53.90
{txt}         41 {c |}{res}     51,072        1.03       54.93
{txt}         42 {c |}{res}     51,072        1.03       55.96
{txt}         43 {c |}{res}     51,072        1.03       56.98
{txt}         44 {c |}{res}     51,072        1.03       58.01
{txt}         45 {c |}{res}     51,072        1.03       59.04
{txt}         46 {c |}{res}     51,072        1.03       60.06
{txt}         47 {c |}{res}     51,072        1.03       61.09
{txt}         48 {c |}{res}     51,072        1.03       62.12
{txt}         49 {c |}{res}     51,072        1.03       63.14
{txt}         50 {c |}{res}     51,072        1.03       64.17
{txt}         51 {c |}{res}     51,072        1.03       65.20
{txt}         52 {c |}{res}     51,072        1.03       66.22
{txt}         53 {c |}{res}     51,072        1.03       67.25
{txt}         54 {c |}{res}     51,072        1.03       68.28
{txt}         55 {c |}{res}     51,072        1.03       69.30
{txt}         56 {c |}{res}     51,072        1.03       70.33
{txt}         57 {c |}{res}     51,072        1.03       71.36
{txt}         58 {c |}{res}     51,072        1.03       72.38
{txt}         59 {c |}{res}     51,072        1.03       73.41
{txt}         60 {c |}{res}     51,072        1.03       74.44
{txt}         61 {c |}{res}     51,072        1.03       75.46
{txt}         62 {c |}{res}     51,072        1.03       76.49
{txt}         63 {c |}{res}     51,072        1.03       77.52
{txt}         64 {c |}{res}     51,072        1.03       78.54
{txt}         65 {c |}{res}     51,072        1.03       79.57
{txt}         66 {c |}{res}     32,455        0.65       80.22
{txt}         67 {c |}{res}     32,455        0.65       80.87
{txt}         68 {c |}{res}     32,455        0.65       81.53
{txt}         69 {c |}{res}     32,455        0.65       82.18
{txt}         70 {c |}{res}     32,455        0.65       82.83
{txt}         71 {c |}{res}     32,455        0.65       83.48
{txt}         72 {c |}{res}     32,455        0.65       84.14
{txt}         73 {c |}{res}     32,455        0.65       84.79
{txt}         74 {c |}{res}     32,455        0.65       85.44
{txt}         75 {c |}{res}     32,455        0.65       86.09
{txt}         76 {c |}{res}     32,455        0.65       86.75
{txt}         77 {c |}{res}     32,455        0.65       87.40
{txt}         78 {c |}{res}     29,394        0.59       87.99
{txt}         79 {c |}{res}     29,394        0.59       88.58
{txt}         80 {c |}{res}     29,394        0.59       89.17
{txt}         81 {c |}{res}     29,394        0.59       89.76
{txt}         82 {c |}{res}     29,394        0.59       90.35
{txt}         83 {c |}{res}     29,394        0.59       90.94
{txt}         84 {c |}{res}     29,394        0.59       91.53
{txt}         85 {c |}{res}     29,394        0.59       92.12
{txt}         86 {c |}{res}     29,394        0.59       92.72
{txt}         87 {c |}{res}     29,394        0.59       93.31
{txt}         88 {c |}{res}     29,394        0.59       93.90
{txt}         89 {c |}{res}     29,394        0.59       94.49
{txt}         90 {c |}{res}     29,394        0.59       95.08
{txt}         91 {c |}{res}     29,394        0.59       95.67
{txt}         92 {c |}{res}     10,158        0.20       95.87
{txt}         93 {c |}{res}     10,082        0.20       96.08
{txt}         94 {c |}{res}     10,082        0.20       96.28
{txt}         95 {c |}{res}     10,082        0.20       96.48
{txt}         96 {c |}{res}     10,082        0.20       96.68
{txt}         97 {c |}{res}      6,064        0.12       96.81
{txt}         98 {c |}{res}      6,064        0.12       96.93
{txt}         99 {c |}{res}      6,064        0.12       97.05
{txt}        100 {c |}{res}      5,463        0.11       97.16
{txt}        101 {c |}{res}      5,463        0.11       97.27
{txt}        102 {c |}{res}      5,463        0.11       97.38
{txt}        103 {c |}{res}      5,463        0.11       97.49
{txt}        104 {c |}{res}      5,463        0.11       97.60
{txt}        105 {c |}{res}      5,463        0.11       97.71
{txt}        106 {c |}{res}      5,463        0.11       97.82
{txt}        107 {c |}{res}      4,574        0.09       97.91
{txt}        108 {c |}{res}      4,574        0.09       98.00
{txt}        109 {c |}{res}      4,574        0.09       98.10
{txt}        110 {c |}{res}      4,574        0.09       98.19
{txt}        111 {c |}{res}      1,620        0.03       98.22
{txt}        112 {c |}{res}      1,620        0.03       98.25
{txt}        113 {c |}{res}      1,620        0.03       98.28
{txt}        114 {c |}{res}      1,620        0.03       98.32
{txt}        115 {c |}{res}      1,620        0.03       98.35
{txt}        116 {c |}{res}      1,620        0.03       98.38
{txt}        117 {c |}{res}      1,620        0.03       98.42
{txt}        118 {c |}{res}      1,620        0.03       98.45
{txt}        119 {c |}{res}      1,620        0.03       98.48
{txt}        120 {c |}{res}        769        0.02       98.50
{txt}        121 {c |}{res}        769        0.02       98.51
{txt}        122 {c |}{res}        769        0.02       98.53
{txt}        123 {c |}{res}        769        0.02       98.54
{txt}        124 {c |}{res}        769        0.02       98.56
{txt}        125 {c |}{res}        769        0.02       98.57
{txt}        126 {c |}{res}        769        0.02       98.59
{txt}        127 {c |}{res}        769        0.02       98.60
{txt}        128 {c |}{res}        769        0.02       98.62
{txt}        129 {c |}{res}        769        0.02       98.63
{txt}        130 {c |}{res}        769        0.02       98.65
{txt}        131 {c |}{res}        769        0.02       98.67
{txt}        132 {c |}{res}        769        0.02       98.68
{txt}        133 {c |}{res}        769        0.02       98.70
{txt}        134 {c |}{res}        769        0.02       98.71
{txt}        135 {c |}{res}        769        0.02       98.73
{txt}        136 {c |}{res}        769        0.02       98.74
{txt}        137 {c |}{res}        769        0.02       98.76
{txt}        138 {c |}{res}        769        0.02       98.77
{txt}        139 {c |}{res}        769        0.02       98.79
{txt}        140 {c |}{res}        769        0.02       98.80
{txt}        141 {c |}{res}        769        0.02       98.82
{txt}        142 {c |}{res}        769        0.02       98.84
{txt}        143 {c |}{res}        769        0.02       98.85
{txt}        144 {c |}{res}        769        0.02       98.87
{txt}        145 {c |}{res}        769        0.02       98.88
{txt}        146 {c |}{res}        769        0.02       98.90
{txt}        147 {c |}{res}        769        0.02       98.91
{txt}        148 {c |}{res}        769        0.02       98.93
{txt}        149 {c |}{res}        769        0.02       98.94
{txt}        150 {c |}{res}        769        0.02       98.96
{txt}        151 {c |}{res}        769        0.02       98.97
{txt}        152 {c |}{res}        769        0.02       98.99
{txt}        153 {c |}{res}        769        0.02       99.01
{txt}        154 {c |}{res}        769        0.02       99.02
{txt}        155 {c |}{res}        769        0.02       99.04
{txt}        156 {c |}{res}        769        0.02       99.05
{txt}        157 {c |}{res}        769        0.02       99.07
{txt}        158 {c |}{res}        769        0.02       99.08
{txt}        159 {c |}{res}        769        0.02       99.10
{txt}        160 {c |}{res}        769        0.02       99.11
{txt}        161 {c |}{res}        769        0.02       99.13
{txt}        162 {c |}{res}        769        0.02       99.14
{txt}        163 {c |}{res}        769        0.02       99.16
{txt}        164 {c |}{res}        769        0.02       99.18
{txt}        165 {c |}{res}        769        0.02       99.19
{txt}        166 {c |}{res}        769        0.02       99.21
{txt}        167 {c |}{res}        769        0.02       99.22
{txt}        168 {c |}{res}        769        0.02       99.24
{txt}        169 {c |}{res}        769        0.02       99.25
{txt}        170 {c |}{res}        769        0.02       99.27
{txt}        171 {c |}{res}        769        0.02       99.28
{txt}        172 {c |}{res}        769        0.02       99.30
{txt}        173 {c |}{res}        769        0.02       99.31
{txt}        174 {c |}{res}        769        0.02       99.33
{txt}        175 {c |}{res}        769        0.02       99.35
{txt}        176 {c |}{res}        769        0.02       99.36
{txt}        177 {c |}{res}        769        0.02       99.38
{txt}        178 {c |}{res}        769        0.02       99.39
{txt}        179 {c |}{res}        769        0.02       99.41
{txt}        180 {c |}{res}        769        0.02       99.42
{txt}        181 {c |}{res}        769        0.02       99.44
{txt}        182 {c |}{res}        769        0.02       99.45
{txt}        183 {c |}{res}        769        0.02       99.47
{txt}        184 {c |}{res}        769        0.02       99.48
{txt}        185 {c |}{res}        769        0.02       99.50
{txt}        186 {c |}{res}        769        0.02       99.52
{txt}        187 {c |}{res}        769        0.02       99.53
{txt}        188 {c |}{res}        769        0.02       99.55
{txt}        189 {c |}{res}        769        0.02       99.56
{txt}        190 {c |}{res}        769        0.02       99.58
{txt}        191 {c |}{res}        769        0.02       99.59
{txt}        192 {c |}{res}        769        0.02       99.61
{txt}        193 {c |}{res}        769        0.02       99.62
{txt}        194 {c |}{res}        769        0.02       99.64
{txt}        195 {c |}{res}        769        0.02       99.66
{txt}        196 {c |}{res}        769        0.02       99.67
{txt}        197 {c |}{res}        216        0.00       99.67
{txt}        198 {c |}{res}        216        0.00       99.68
{txt}        199 {c |}{res}        216        0.00       99.68
{txt}        200 {c |}{res}        216        0.00       99.69
{txt}        201 {c |}{res}        216        0.00       99.69
{txt}        202 {c |}{res}        216        0.00       99.70
{txt}        203 {c |}{res}        216        0.00       99.70
{txt}        204 {c |}{res}        216        0.00       99.71
{txt}        205 {c |}{res}        216        0.00       99.71
{txt}        206 {c |}{res}        216        0.00       99.71
{txt}        207 {c |}{res}        216        0.00       99.72
{txt}        208 {c |}{res}        216        0.00       99.72
{txt}        209 {c |}{res}        216        0.00       99.73
{txt}        210 {c |}{res}        216        0.00       99.73
{txt}        211 {c |}{res}        216        0.00       99.74
{txt}        212 {c |}{res}        216        0.00       99.74
{txt}        213 {c |}{res}        216        0.00       99.74
{txt}        214 {c |}{res}        216        0.00       99.75
{txt}        215 {c |}{res}        216        0.00       99.75
{txt}        216 {c |}{res}        132        0.00       99.76
{txt}        217 {c |}{res}        132        0.00       99.76
{txt}        218 {c |}{res}        132        0.00       99.76
{txt}        219 {c |}{res}        132        0.00       99.76
{txt}        220 {c |}{res}        132        0.00       99.77
{txt}        221 {c |}{res}        132        0.00       99.77
{txt}        222 {c |}{res}        132        0.00       99.77
{txt}        223 {c |}{res}        132        0.00       99.77
{txt}        224 {c |}{res}         96        0.00       99.78
{txt}        225 {c |}{res}         96        0.00       99.78
{txt}        226 {c |}{res}         96        0.00       99.78
{txt}        227 {c |}{res}         96        0.00       99.78
{txt}        228 {c |}{res}         96        0.00       99.78
{txt}        229 {c |}{res}         48        0.00       99.78
{txt}        230 {c |}{res}         48        0.00       99.79
{txt}        231 {c |}{res}         48        0.00       99.79
{txt}        232 {c |}{res}         48        0.00       99.79
{txt}        233 {c |}{res}         48        0.00       99.79
{txt}        234 {c |}{res}         48        0.00       99.79
{txt}        235 {c |}{res}         48        0.00       99.79
{txt}        236 {c |}{res}         48        0.00       99.79
{txt}        237 {c |}{res}         48        0.00       99.79
{txt}        238 {c |}{res}         48        0.00       99.79
{txt}        239 {c |}{res}         48        0.00       99.79
{txt}        240 {c |}{res}         48        0.00       99.80
{txt}        241 {c |}{res}         48        0.00       99.80
{txt}        242 {c |}{res}         48        0.00       99.80
{txt}        243 {c |}{res}         48        0.00       99.80
{txt}        244 {c |}{res}         48        0.00       99.80
{txt}        245 {c |}{res}         48        0.00       99.80
{txt}        246 {c |}{res}         48        0.00       99.80
{txt}        247 {c |}{res}         48        0.00       99.80
{txt}        248 {c |}{res}         48        0.00       99.80
{txt}        249 {c |}{res}         48        0.00       99.80
{txt}        250 {c |}{res}         48        0.00       99.81
{txt}        251 {c |}{res}         48        0.00       99.81
{txt}        252 {c |}{res}         48        0.00       99.81
{txt}        253 {c |}{res}         48        0.00       99.81
{txt}        254 {c |}{res}         48        0.00       99.81
{txt}        255 {c |}{res}         48        0.00       99.81
{txt}        256 {c |}{res}         48        0.00       99.81
{txt}        257 {c |}{res}         48        0.00       99.81
{txt}        258 {c |}{res}         48        0.00       99.81
{txt}        259 {c |}{res}         48        0.00       99.81
{txt}        260 {c |}{res}         48        0.00       99.81
{txt}        261 {c |}{res}         36        0.00       99.82
{txt}        262 {c |}{res}         36        0.00       99.82
{txt}        263 {c |}{res}         36        0.00       99.82
{txt}        264 {c |}{res}         36        0.00       99.82
{txt}        265 {c |}{res}         36        0.00       99.82
{txt}        266 {c |}{res}         36        0.00       99.82
{txt}        267 {c |}{res}         36        0.00       99.82
{txt}        268 {c |}{res}         36        0.00       99.82
{txt}        269 {c |}{res}         36        0.00       99.82
{txt}        270 {c |}{res}         36        0.00       99.82
{txt}        271 {c |}{res}         36        0.00       99.82
{txt}        272 {c |}{res}         36        0.00       99.82
{txt}        273 {c |}{res}         36        0.00       99.82
{txt}        274 {c |}{res}         36        0.00       99.82
{txt}        275 {c |}{res}         36        0.00       99.83
{txt}        276 {c |}{res}         36        0.00       99.83
{txt}        277 {c |}{res}         36        0.00       99.83
{txt}        278 {c |}{res}         36        0.00       99.83
{txt}        279 {c |}{res}         36        0.00       99.83
{txt}        280 {c |}{res}         36        0.00       99.83
{txt}        281 {c |}{res}         36        0.00       99.83
{txt}        282 {c |}{res}         36        0.00       99.83
{txt}        283 {c |}{res}         36        0.00       99.83
{txt}        284 {c |}{res}         36        0.00       99.83
{txt}        285 {c |}{res}         36        0.00       99.83
{txt}        286 {c |}{res}         36        0.00       99.83
{txt}        287 {c |}{res}         36        0.00       99.83
{txt}        288 {c |}{res}         36        0.00       99.84
{txt}        289 {c |}{res}         36        0.00       99.84
{txt}        290 {c |}{res}         36        0.00       99.84
{txt}        291 {c |}{res}         36        0.00       99.84
{txt}        292 {c |}{res}         36        0.00       99.84
{txt}        293 {c |}{res}         36        0.00       99.84
{txt}        294 {c |}{res}         36        0.00       99.84
{txt}        295 {c |}{res}         36        0.00       99.84
{txt}        296 {c |}{res}         36        0.00       99.84
{txt}        297 {c |}{res}         36        0.00       99.84
{txt}        298 {c |}{res}         36        0.00       99.84
{txt}        299 {c |}{res}         36        0.00       99.84
{txt}        300 {c |}{res}         36        0.00       99.84
{txt}        301 {c |}{res}         36        0.00       99.84
{txt}        302 {c |}{res}         36        0.00       99.85
{txt}        303 {c |}{res}         36        0.00       99.85
{txt}        304 {c |}{res}         36        0.00       99.85
{txt}        305 {c |}{res}         36        0.00       99.85
{txt}        306 {c |}{res}         36        0.00       99.85
{txt}        307 {c |}{res}         36        0.00       99.85
{txt}        308 {c |}{res}         36        0.00       99.85
{txt}        309 {c |}{res}         36        0.00       99.85
{txt}        310 {c |}{res}         36        0.00       99.85
{txt}        311 {c |}{res}         36        0.00       99.85
{txt}        312 {c |}{res}         36        0.00       99.85
{txt}        313 {c |}{res}         36        0.00       99.85
{txt}        314 {c |}{res}         36        0.00       99.85
{txt}        315 {c |}{res}         36        0.00       99.85
{txt}        316 {c |}{res}         36        0.00       99.86
{txt}        317 {c |}{res}         36        0.00       99.86
{txt}        318 {c |}{res}         36        0.00       99.86
{txt}        319 {c |}{res}         36        0.00       99.86
{txt}        320 {c |}{res}         36        0.00       99.86
{txt}        321 {c |}{res}         36        0.00       99.86
{txt}        322 {c |}{res}         36        0.00       99.86
{txt}        323 {c |}{res}         36        0.00       99.86
{txt}        324 {c |}{res}         36        0.00       99.86
{txt}        325 {c |}{res}         36        0.00       99.86
{txt}        326 {c |}{res}         36        0.00       99.86
{txt}        327 {c |}{res}         36        0.00       99.86
{txt}        328 {c |}{res}         36        0.00       99.86
{txt}        329 {c |}{res}         36        0.00       99.86
{txt}        330 {c |}{res}         36        0.00       99.87
{txt}        331 {c |}{res}         36        0.00       99.87
{txt}        332 {c |}{res}         36        0.00       99.87
{txt}        333 {c |}{res}         36        0.00       99.87
{txt}        334 {c |}{res}         36        0.00       99.87
{txt}        335 {c |}{res}         36        0.00       99.87
{txt}        336 {c |}{res}         36        0.00       99.87
{txt}        337 {c |}{res}         36        0.00       99.87
{txt}        338 {c |}{res}         36        0.00       99.87
{txt}        339 {c |}{res}         36        0.00       99.87
{txt}        340 {c |}{res}         36        0.00       99.87
{txt}        341 {c |}{res}         36        0.00       99.87
{txt}        342 {c |}{res}         36        0.00       99.87
{txt}        343 {c |}{res}         36        0.00       99.87
{txt}        344 {c |}{res}         36        0.00       99.88
{txt}        345 {c |}{res}         36        0.00       99.88
{txt}        346 {c |}{res}         36        0.00       99.88
{txt}        347 {c |}{res}         36        0.00       99.88
{txt}        348 {c |}{res}         36        0.00       99.88
{txt}        349 {c |}{res}         36        0.00       99.88
{txt}        350 {c |}{res}         36        0.00       99.88
{txt}        351 {c |}{res}         36        0.00       99.88
{txt}        352 {c |}{res}         36        0.00       99.88
{txt}        353 {c |}{res}         36        0.00       99.88
{txt}        354 {c |}{res}         36        0.00       99.88
{txt}        355 {c |}{res}         36        0.00       99.88
{txt}        356 {c |}{res}         36        0.00       99.88
{txt}        357 {c |}{res}         36        0.00       99.88
{txt}        358 {c |}{res}         36        0.00       99.89
{txt}        359 {c |}{res}         36        0.00       99.89
{txt}        360 {c |}{res}         36        0.00       99.89
{txt}        361 {c |}{res}         36        0.00       99.89
{txt}        362 {c |}{res}         36        0.00       99.89
{txt}        363 {c |}{res}         36        0.00       99.89
{txt}        364 {c |}{res}         36        0.00       99.89
{txt}        365 {c |}{res}         36        0.00       99.89
{txt}        366 {c |}{res}         36        0.00       99.89
{txt}        367 {c |}{res}         36        0.00       99.89
{txt}        368 {c |}{res}         36        0.00       99.89
{txt}        369 {c |}{res}         36        0.00       99.89
{txt}        370 {c |}{res}         36        0.00       99.89
{txt}        371 {c |}{res}         36        0.00       99.90
{txt}        372 {c |}{res}         36        0.00       99.90
{txt}        373 {c |}{res}         36        0.00       99.90
{txt}        374 {c |}{res}         36        0.00       99.90
{txt}        375 {c |}{res}         36        0.00       99.90
{txt}        376 {c |}{res}         36        0.00       99.90
{txt}        377 {c |}{res}         36        0.00       99.90
{txt}        378 {c |}{res}         36        0.00       99.90
{txt}        379 {c |}{res}         36        0.00       99.90
{txt}        380 {c |}{res}         36        0.00       99.90
{txt}        381 {c |}{res}         36        0.00       99.90
{txt}        382 {c |}{res}         36        0.00       99.90
{txt}        383 {c |}{res}         36        0.00       99.90
{txt}        384 {c |}{res}         36        0.00       99.90
{txt}        385 {c |}{res}         36        0.00       99.91
{txt}        386 {c |}{res}         36        0.00       99.91
{txt}        387 {c |}{res}         36        0.00       99.91
{txt}        388 {c |}{res}         36        0.00       99.91
{txt}        389 {c |}{res}         36        0.00       99.91
{txt}        390 {c |}{res}         36        0.00       99.91
{txt}        391 {c |}{res}         36        0.00       99.91
{txt}        392 {c |}{res}         36        0.00       99.91
{txt}        393 {c |}{res}         36        0.00       99.91
{txt}        394 {c |}{res}         36        0.00       99.91
{txt}        395 {c |}{res}         36        0.00       99.91
{txt}        396 {c |}{res}         36        0.00       99.91
{txt}        397 {c |}{res}         36        0.00       99.91
{txt}        398 {c |}{res}         36        0.00       99.91
{txt}        399 {c |}{res}         36        0.00       99.92
{txt}        400 {c |}{res}         36        0.00       99.92
{txt}        401 {c |}{res}         36        0.00       99.92
{txt}        402 {c |}{res}         36        0.00       99.92
{txt}        403 {c |}{res}         36        0.00       99.92
{txt}        404 {c |}{res}         36        0.00       99.92
{txt}        405 {c |}{res}         36        0.00       99.92
{txt}        406 {c |}{res}         36        0.00       99.92
{txt}        407 {c |}{res}         36        0.00       99.92
{txt}        408 {c |}{res}         36        0.00       99.92
{txt}        409 {c |}{res}         36        0.00       99.92
{txt}        410 {c |}{res}         36        0.00       99.92
{txt}        411 {c |}{res}         36        0.00       99.92
{txt}        412 {c |}{res}         36        0.00       99.92
{txt}        413 {c |}{res}         36        0.00       99.93
{txt}        414 {c |}{res}         36        0.00       99.93
{txt}        415 {c |}{res}         36        0.00       99.93
{txt}        416 {c |}{res}         36        0.00       99.93
{txt}        417 {c |}{res}         36        0.00       99.93
{txt}        418 {c |}{res}         36        0.00       99.93
{txt}        419 {c |}{res}         36        0.00       99.93
{txt}        420 {c |}{res}         36        0.00       99.93
{txt}        421 {c |}{res}         36        0.00       99.93
{txt}        422 {c |}{res}         36        0.00       99.93
{txt}        423 {c |}{res}         36        0.00       99.93
{txt}        424 {c |}{res}         36        0.00       99.93
{txt}        425 {c |}{res}         36        0.00       99.93
{txt}        426 {c |}{res}         36        0.00       99.93
{txt}        427 {c |}{res}         36        0.00       99.94
{txt}        428 {c |}{res}         36        0.00       99.94
{txt}        429 {c |}{res}         36        0.00       99.94
{txt}        430 {c |}{res}         36        0.00       99.94
{txt}        431 {c |}{res}         36        0.00       99.94
{txt}        432 {c |}{res}         36        0.00       99.94
{txt}        433 {c |}{res}         36        0.00       99.94
{txt}        434 {c |}{res}         36        0.00       99.94
{txt}        435 {c |}{res}         36        0.00       99.94
{txt}        436 {c |}{res}         36        0.00       99.94
{txt}        437 {c |}{res}         36        0.00       99.94
{txt}        438 {c |}{res}         36        0.00       99.94
{txt}        439 {c |}{res}         36        0.00       99.94
{txt}        440 {c |}{res}         36        0.00       99.95
{txt}        441 {c |}{res}         36        0.00       99.95
{txt}        442 {c |}{res}         36        0.00       99.95
{txt}        443 {c |}{res}         36        0.00       99.95
{txt}        444 {c |}{res}         36        0.00       99.95
{txt}        445 {c |}{res}         36        0.00       99.95
{txt}        446 {c |}{res}         36        0.00       99.95
{txt}        447 {c |}{res}         36        0.00       99.95
{txt}        448 {c |}{res}         36        0.00       99.95
{txt}        449 {c |}{res}         36        0.00       99.95
{txt}        450 {c |}{res}         36        0.00       99.95
{txt}        451 {c |}{res}         36        0.00       99.95
{txt}        452 {c |}{res}         36        0.00       99.95
{txt}        453 {c |}{res}         36        0.00       99.95
{txt}        454 {c |}{res}         36        0.00       99.96
{txt}        455 {c |}{res}         36        0.00       99.96
{txt}        456 {c |}{res}         36        0.00       99.96
{txt}        457 {c |}{res}         36        0.00       99.96
{txt}        458 {c |}{res}         36        0.00       99.96
{txt}        459 {c |}{res}         36        0.00       99.96
{txt}        460 {c |}{res}         36        0.00       99.96
{txt}        461 {c |}{res}         36        0.00       99.96
{txt}        462 {c |}{res}         36        0.00       99.96
{txt}        463 {c |}{res}         36        0.00       99.96
{txt}        464 {c |}{res}         36        0.00       99.96
{txt}        465 {c |}{res}         36        0.00       99.96
{txt}        466 {c |}{res}         36        0.00       99.96
{txt}        467 {c |}{res}         36        0.00       99.96
{txt}        468 {c |}{res}         36        0.00       99.97
{txt}        469 {c |}{res}         36        0.00       99.97
{txt}        470 {c |}{res}         36        0.00       99.97
{txt}        471 {c |}{res}         36        0.00       99.97
{txt}        472 {c |}{res}         36        0.00       99.97
{txt}        473 {c |}{res}         36        0.00       99.97
{txt}        474 {c |}{res}         36        0.00       99.97
{txt}        475 {c |}{res}         36        0.00       99.97
{txt}        476 {c |}{res}         36        0.00       99.97
{txt}        477 {c |}{res}         36        0.00       99.97
{txt}        478 {c |}{res}         36        0.00       99.97
{txt}        479 {c |}{res}         36        0.00       99.97
{txt}        480 {c |}{res}         36        0.00       99.97
{txt}        481 {c |}{res}         36        0.00       99.97
{txt}        482 {c |}{res}         36        0.00       99.98
{txt}        483 {c |}{res}         36        0.00       99.98
{txt}        484 {c |}{res}         36        0.00       99.98
{txt}        485 {c |}{res}         36        0.00       99.98
{txt}        486 {c |}{res}         36        0.00       99.98
{txt}        487 {c |}{res}         36        0.00       99.98
{txt}        488 {c |}{res}         36        0.00       99.98
{txt}        489 {c |}{res}         36        0.00       99.98
{txt}        490 {c |}{res}         36        0.00       99.98
{txt}        491 {c |}{res}         36        0.00       99.98
{txt}        492 {c |}{res}         36        0.00       99.98
{txt}        493 {c |}{res}         36        0.00       99.98
{txt}        494 {c |}{res}         36        0.00       99.98
{txt}        495 {c |}{res}         36        0.00       99.98
{txt}        496 {c |}{res}         36        0.00       99.99
{txt}        497 {c |}{res}         36        0.00       99.99
{txt}        498 {c |}{res}         36        0.00       99.99
{txt}        499 {c |}{res}         36        0.00       99.99
{txt}        500 {c |}{res}         36        0.00       99.99
{txt}        501 {c |}{res}         36        0.00       99.99
{txt}        502 {c |}{res}         36        0.00       99.99
{txt}        503 {c |}{res}         36        0.00       99.99
{txt}        504 {c |}{res}         36        0.00       99.99
{txt}        505 {c |}{res}         36        0.00       99.99
{txt}        506 {c |}{res}         36        0.00       99.99
{txt}        507 {c |}{res}         36        0.00       99.99
{txt}        508 {c |}{res}         36        0.00       99.99
{txt}        509 {c |}{res}         36        0.00       99.99
{txt}        510 {c |}{res}         36        0.00      100.00
{txt}        511 {c |}{res}         36        0.00      100.00
{txt}        512 {c |}{res}         36        0.00      100.00
{txt}        513 {c |}{res}         36        0.00      100.00
{txt}        514 {c |}{res}         36        0.00      100.00
{txt}        515 {c |}{res}         36        0.00      100.00
{txt}        516 {c |}{res}         36        0.00      100.00
{txt}{hline 12}{c +}{hline 35}
      Total {c |}{res}  4,974,631      100.00
{txt}
{com}. 
. by ts, sort: replace panel_e=_n 
{txt}(4,974,111 real changes made)

{com}. replace added_e = 1 if added_e == . 
{txt}(3,785,047 real changes made)

{com}. drop if panel_e > 1 & added_e == 1 
{txt}(3,784,565 observations deleted)

{com}. 
. gen eei_binf = 0 
{txt}
{com}. sum ts, meanonly                // only integers, continous list 
{txt}
{com}. forvalues i=`r(min)'(1)`r(max)' {c -(} 
{txt}  2{com}.         replace eei_binf=((`i') + 26)/2 if ts==`i'
{txt}  3{com}. {c )-}
{txt}(689,647 real changes made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(2 real changes made)
(1 real change made)
(1 real change made)
(64 real changes made)
(178 real changes made)
(1 real change made)
(14 real changes made)
(1 real change made)
(1 real change made)
(519 real changes made)
(1 real change made)
(1 real change made)
(1,034 real changes made)
(1,478 real changes made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(100 real changes made)
(1 real change made)
(51 real changes made)
(316 real changes made)
(3,330 real changes made)
(330 real changes made)
(74 real changes made)
(85 real changes made)
(37 real changes made)
(1,016 real changes made)
(1 real change made)
(27 real changes made)
(1 real change made)
(3,597 real changes made)
(16,063 real changes made)
(617 real changes made)
(417 real changes made)
(109 real changes made)
(1 real change made)
(133 real changes made)
(562 real changes made)
(734 real changes made)
(5,865 real changes made)
(5,964 real changes made)
(433 real changes made)
(1,416 real changes made)
(2,838 real changes made)
(2,595 real changes made)
(1,561 real changes made)
(4,117 real changes made)
(917 real changes made)
(2,748 real changes made)
(9,071 real changes made)
(1,730 real changes made)
(8,764 real changes made)
(5,028 real changes made)
(10,428 real changes made)
(7,644 real changes made)
(21,741 real changes made)
(24,172 real changes made)
(18,580 real changes made)
(51,072 real changes made)
(1,495 real changes made)
(2,258 real changes made)
(1,850 real changes made)
(1,923 real changes made)
(1,874 real changes made)
(2,360 real changes made)
(10,828 real changes made)
(2,242 real changes made)
(7,346 real changes made)
(24,178 real changes made)
(8,376 real changes made)
(32,455 real changes made)
(6,681 real changes made)
(656 real changes made)
(1,756 real changes made)
(3,024 real changes made)
(1,206 real changes made)
(3,122 real changes made)
(11,874 real changes made)
(3,884 real changes made)
(5,469 real changes made)
(9,163 real changes made)
(5,348 real changes made)
(14,117 real changes made)
(20,315 real changes made)
(29,394 real changes made)
(10,158 real changes made)
(3,278 real changes made)
(733 real changes made)
(1,621 real changes made)
(10,082 real changes made)
(853 real changes made)
(397 real changes made)
(6,064 real changes made)
(746 real changes made)
(2,451 real changes made)
(578 real changes made)
(746 real changes made)
(3,103 real changes made)
(637 real changes made)
(5,463 real changes made)
(1 real change made)
(3,254 real changes made)
(2,340 real changes made)
(4,574 real changes made)
(984 real changes made)
(217 real changes made)
(1,260 real changes made)
(61 real changes made)
(276 real changes made)
(445 real changes made)
(481 real changes made)
(241 real changes made)
(1,620 real changes made)
(86 real changes made)
(433 real changes made)
(1 real change made)
(240 real changes made)
(673 real changes made)
(85 real changes made)
(157 real changes made)
(576 real changes made)
(206 real changes made)
(1 real change made)
(157 real changes made)
(85 real changes made)
(97 real changes made)
(157 real changes made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(13 real changes made)
(1 real change made)
(1 real change made)
(157 real changes made)
(1 real change made)
(62 real changes made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(121 real changes made)
(265 real changes made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(97 real changes made)
(1 real change made)
(36 real changes made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(14 real changes made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(25 real changes made)
(652 real changes made)
(1 real change made)
(1 real change made)
(1 real change made)
(133 real changes made)
(1 real change made)
(1 real change made)
(145 real changes made)
(1 real change made)
(1 real change made)
(217 real changes made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(145 real changes made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(769 real changes made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(181 real changes made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(216 real changes made)
(1 real change made)
(1 real change made)
(85 real changes made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(132 real changes made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(96 real changes made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(12 real changes made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(48 real changes made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(36 real changes made)

{com}. 
. tab eei_binf                                                               // check. starts at 13.5 goes to 143. 

   {txt}eei_binf {c |}      Freq.     Percent        Cum.
{hline 12}{c +}{hline 35}
       13.5 {c |}{res}    689,647       57.95       57.95
{txt}         14 {c |}{res}          1        0.00       57.95
{txt}       14.5 {c |}{res}          1        0.00       57.95
{txt}         15 {c |}{res}          1        0.00       57.95
{txt}       15.5 {c |}{res}          1        0.00       57.95
{txt}         16 {c |}{res}          2        0.00       57.95
{txt}       16.5 {c |}{res}          1        0.00       57.95
{txt}         17 {c |}{res}          1        0.00       57.95
{txt}       17.5 {c |}{res}         64        0.01       57.96
{txt}         18 {c |}{res}        178        0.01       57.97
{txt}       18.5 {c |}{res}          1        0.00       57.97
{txt}         19 {c |}{res}         14        0.00       57.97
{txt}       19.5 {c |}{res}          1        0.00       57.97
{txt}         20 {c |}{res}          1        0.00       57.97
{txt}       20.5 {c |}{res}        519        0.04       58.02
{txt}         21 {c |}{res}          1        0.00       58.02
{txt}       21.5 {c |}{res}          1        0.00       58.02
{txt}         22 {c |}{res}      1,034        0.09       58.10
{txt}       22.5 {c |}{res}      1,478        0.12       58.23
{txt}         23 {c |}{res}          1        0.00       58.23
{txt}       23.5 {c |}{res}          1        0.00       58.23
{txt}         24 {c |}{res}          1        0.00       58.23
{txt}       24.5 {c |}{res}          1        0.00       58.23
{txt}         25 {c |}{res}        100        0.01       58.24
{txt}       25.5 {c |}{res}          1        0.00       58.24
{txt}         26 {c |}{res}         51        0.00       58.24
{txt}       26.5 {c |}{res}        316        0.03       58.27
{txt}         27 {c |}{res}      3,330        0.28       58.55
{txt}       27.5 {c |}{res}        330        0.03       58.57
{txt}         28 {c |}{res}         74        0.01       58.58
{txt}       28.5 {c |}{res}         85        0.01       58.59
{txt}         29 {c |}{res}         37        0.00       58.59
{txt}       29.5 {c |}{res}      1,016        0.09       58.68
{txt}         30 {c |}{res}          1        0.00       58.68
{txt}       30.5 {c |}{res}         27        0.00       58.68
{txt}         31 {c |}{res}          1        0.00       58.68
{txt}       31.5 {c |}{res}      3,597        0.30       58.98
{txt}         32 {c |}{res}     16,063        1.35       60.33
{txt}       32.5 {c |}{res}        617        0.05       60.38
{txt}         33 {c |}{res}        417        0.04       60.42
{txt}       33.5 {c |}{res}        109        0.01       60.43
{txt}         34 {c |}{res}          1        0.00       60.43
{txt}       34.5 {c |}{res}        133        0.01       60.44
{txt}         35 {c |}{res}        562        0.05       60.49
{txt}       35.5 {c |}{res}        734        0.06       60.55
{txt}         36 {c |}{res}      5,865        0.49       61.04
{txt}       36.5 {c |}{res}      5,964        0.50       61.54
{txt}         37 {c |}{res}        433        0.04       61.58
{txt}       37.5 {c |}{res}      1,416        0.12       61.70
{txt}         38 {c |}{res}      2,838        0.24       61.94
{txt}       38.5 {c |}{res}      2,595        0.22       62.15
{txt}         39 {c |}{res}      1,561        0.13       62.28
{txt}       39.5 {c |}{res}      4,117        0.35       62.63
{txt}         40 {c |}{res}        917        0.08       62.71
{txt}       40.5 {c |}{res}      2,748        0.23       62.94
{txt}         41 {c |}{res}      9,071        0.76       63.70
{txt}       41.5 {c |}{res}      1,730        0.15       63.85
{txt}         42 {c |}{res}      8,764        0.74       64.58
{txt}       42.5 {c |}{res}      5,028        0.42       65.00
{txt}         43 {c |}{res}     10,428        0.88       65.88
{txt}       43.5 {c |}{res}      7,644        0.64       66.52
{txt}         44 {c |}{res}     21,741        1.83       68.35
{txt}       44.5 {c |}{res}     24,172        2.03       70.38
{txt}         45 {c |}{res}     18,580        1.56       71.94
{txt}       45.5 {c |}{res}     51,072        4.29       76.23
{txt}         46 {c |}{res}      1,495        0.13       76.36
{txt}       46.5 {c |}{res}      2,258        0.19       76.55
{txt}         47 {c |}{res}      1,850        0.16       76.70
{txt}       47.5 {c |}{res}      1,923        0.16       76.87
{txt}         48 {c |}{res}      1,874        0.16       77.02
{txt}       48.5 {c |}{res}      2,360        0.20       77.22
{txt}         49 {c |}{res}     10,828        0.91       78.13
{txt}       49.5 {c |}{res}      2,242        0.19       78.32
{txt}         50 {c |}{res}      7,346        0.62       78.94
{txt}       50.5 {c |}{res}     24,178        2.03       80.97
{txt}         51 {c |}{res}      8,376        0.70       81.67
{txt}       51.5 {c |}{res}     32,455        2.73       84.40
{txt}         52 {c |}{res}      6,681        0.56       84.96
{txt}       52.5 {c |}{res}        656        0.06       85.02
{txt}         53 {c |}{res}      1,756        0.15       85.16
{txt}       53.5 {c |}{res}      3,024        0.25       85.42
{txt}         54 {c |}{res}      1,206        0.10       85.52
{txt}       54.5 {c |}{res}      3,122        0.26       85.78
{txt}         55 {c |}{res}     11,874        1.00       86.78
{txt}       55.5 {c |}{res}      3,884        0.33       87.11
{txt}         56 {c |}{res}      5,469        0.46       87.57
{txt}       56.5 {c |}{res}      9,163        0.77       88.34
{txt}         57 {c |}{res}      5,348        0.45       88.79
{txt}       57.5 {c |}{res}     14,117        1.19       89.97
{txt}         58 {c |}{res}     20,315        1.71       91.68
{txt}       58.5 {c |}{res}     29,394        2.47       94.15
{txt}         59 {c |}{res}     10,158        0.85       95.00
{txt}       59.5 {c |}{res}      3,278        0.28       95.28
{txt}         60 {c |}{res}        733        0.06       95.34
{txt}       60.5 {c |}{res}      1,621        0.14       95.48
{txt}         61 {c |}{res}     10,082        0.85       96.32
{txt}       61.5 {c |}{res}        853        0.07       96.39
{txt}         62 {c |}{res}        397        0.03       96.43
{txt}       62.5 {c |}{res}      6,064        0.51       96.94
{txt}         63 {c |}{res}        746        0.06       97.00
{txt}       63.5 {c |}{res}      2,451        0.21       97.21
{txt}         64 {c |}{res}        578        0.05       97.25
{txt}       64.5 {c |}{res}        746        0.06       97.32
{txt}         65 {c |}{res}      3,103        0.26       97.58
{txt}       65.5 {c |}{res}        637        0.05       97.63
{txt}         66 {c |}{res}      5,463        0.46       98.09
{txt}       66.5 {c |}{res}          1        0.00       98.09
{txt}         67 {c |}{res}      3,254        0.27       98.36
{txt}       67.5 {c |}{res}      2,340        0.20       98.56
{txt}         68 {c |}{res}      4,574        0.38       98.94
{txt}       68.5 {c |}{res}        984        0.08       99.03
{txt}         69 {c |}{res}        217        0.02       99.05
{txt}       69.5 {c |}{res}      1,260        0.11       99.15
{txt}         70 {c |}{res}         61        0.01       99.16
{txt}       70.5 {c |}{res}        276        0.02       99.18
{txt}         71 {c |}{res}        445        0.04       99.22
{txt}       71.5 {c |}{res}        481        0.04       99.26
{txt}         72 {c |}{res}        241        0.02       99.28
{txt}       72.5 {c |}{res}      1,620        0.14       99.41
{txt}         73 {c |}{res}         86        0.01       99.42
{txt}       73.5 {c |}{res}        433        0.04       99.46
{txt}         74 {c |}{res}          1        0.00       99.46
{txt}       74.5 {c |}{res}        240        0.02       99.48
{txt}         75 {c |}{res}        673        0.06       99.53
{txt}       75.5 {c |}{res}         85        0.01       99.54
{txt}         76 {c |}{res}        157        0.01       99.55
{txt}       76.5 {c |}{res}        576        0.05       99.60
{txt}         77 {c |}{res}        206        0.02       99.62
{txt}       77.5 {c |}{res}          1        0.00       99.62
{txt}         78 {c |}{res}        157        0.01       99.63
{txt}       78.5 {c |}{res}         85        0.01       99.64
{txt}         79 {c |}{res}         97        0.01       99.65
{txt}       79.5 {c |}{res}        157        0.01       99.66
{txt}         80 {c |}{res}          1        0.00       99.66
{txt}       80.5 {c |}{res}          1        0.00       99.66
{txt}         81 {c |}{res}          1        0.00       99.66
{txt}       81.5 {c |}{res}          1        0.00       99.66
{txt}         82 {c |}{res}          1        0.00       99.66
{txt}       82.5 {c |}{res}          1        0.00       99.66
{txt}         83 {c |}{res}          1        0.00       99.66
{txt}       83.5 {c |}{res}         13        0.00       99.66
{txt}         84 {c |}{res}          1        0.00       99.66
{txt}       84.5 {c |}{res}          1        0.00       99.66
{txt}         85 {c |}{res}        157        0.01       99.68
{txt}       85.5 {c |}{res}          1        0.00       99.68
{txt}         86 {c |}{res}         62        0.01       99.68
{txt}       86.5 {c |}{res}          1        0.00       99.68
{txt}         87 {c |}{res}          1        0.00       99.68
{txt}       87.5 {c |}{res}          1        0.00       99.68
{txt}         88 {c |}{res}          1        0.00       99.68
{txt}       88.5 {c |}{res}        121        0.01       99.69
{txt}         89 {c |}{res}        265        0.02       99.72
{txt}       89.5 {c |}{res}          1        0.00       99.72
{txt}         90 {c |}{res}          1        0.00       99.72
{txt}       90.5 {c |}{res}          1        0.00       99.72
{txt}         91 {c |}{res}          1        0.00       99.72
{txt}       91.5 {c |}{res}         97        0.01       99.72
{txt}         92 {c |}{res}          1        0.00       99.72
{txt}       92.5 {c |}{res}         36        0.00       99.73
{txt}         93 {c |}{res}          1        0.00       99.73
{txt}       93.5 {c |}{res}          1        0.00       99.73
{txt}         94 {c |}{res}          1        0.00       99.73
{txt}       94.5 {c |}{res}          1        0.00       99.73
{txt}         95 {c |}{res}          1        0.00       99.73
{txt}       95.5 {c |}{res}          1        0.00       99.73
{txt}         96 {c |}{res}         14        0.00       99.73
{txt}       96.5 {c |}{res}          1        0.00       99.73
{txt}         97 {c |}{res}          1        0.00       99.73
{txt}       97.5 {c |}{res}          1        0.00       99.73
{txt}         98 {c |}{res}          1        0.00       99.73
{txt}       98.5 {c |}{res}          1        0.00       99.73
{txt}         99 {c |}{res}          1        0.00       99.73
{txt}       99.5 {c |}{res}         25        0.00       99.73
{txt}        100 {c |}{res}        652        0.05       99.79
{txt}      100.5 {c |}{res}          1        0.00       99.79
{txt}        101 {c |}{res}          1        0.00       99.79
{txt}      101.5 {c |}{res}          1        0.00       99.79
{txt}        102 {c |}{res}        133        0.01       99.80
{txt}      102.5 {c |}{res}          1        0.00       99.80
{txt}        103 {c |}{res}          1        0.00       99.80
{txt}      103.5 {c |}{res}        145        0.01       99.81
{txt}        104 {c |}{res}          1        0.00       99.81
{txt}      104.5 {c |}{res}          1        0.00       99.81
{txt}        105 {c |}{res}        217        0.02       99.83
{txt}      105.5 {c |}{res}          1        0.00       99.83
{txt}        106 {c |}{res}          1        0.00       99.83
{txt}      106.5 {c |}{res}          1        0.00       99.83
{txt}        107 {c |}{res}          1        0.00       99.83
{txt}      107.5 {c |}{res}          1        0.00       99.83
{txt}        108 {c |}{res}        145        0.01       99.84
{txt}      108.5 {c |}{res}          1        0.00       99.84
{txt}        109 {c |}{res}          1        0.00       99.84
{txt}      109.5 {c |}{res}          1        0.00       99.84
{txt}        110 {c |}{res}          1        0.00       99.84
{txt}      110.5 {c |}{res}          1        0.00       99.84
{txt}        111 {c |}{res}        769        0.06       99.91
{txt}      111.5 {c |}{res}          1        0.00       99.91
{txt}        112 {c |}{res}          1        0.00       99.91
{txt}      112.5 {c |}{res}          1        0.00       99.91
{txt}        113 {c |}{res}          1        0.00       99.91
{txt}      113.5 {c |}{res}          1        0.00       99.91
{txt}        114 {c |}{res}        181        0.02       99.92
{txt}      114.5 {c |}{res}          1        0.00       99.92
{txt}        115 {c |}{res}          1        0.00       99.92
{txt}      115.5 {c |}{res}          1        0.00       99.92
{txt}        116 {c |}{res}          1        0.00       99.92
{txt}      116.5 {c |}{res}          1        0.00       99.92
{txt}        117 {c |}{res}          1        0.00       99.92
{txt}      117.5 {c |}{res}          1        0.00       99.92
{txt}        118 {c |}{res}          1        0.00       99.92
{txt}      118.5 {c |}{res}          1        0.00       99.92
{txt}        119 {c |}{res}          1        0.00       99.92
{txt}      119.5 {c |}{res}          1        0.00       99.92
{txt}        120 {c |}{res}          1        0.00       99.92
{txt}      120.5 {c |}{res}        216        0.02       99.94
{txt}        121 {c |}{res}          1        0.00       99.94
{txt}      121.5 {c |}{res}          1        0.00       99.94
{txt}        122 {c |}{res}         85        0.01       99.95
{txt}      122.5 {c |}{res}          1        0.00       99.95
{txt}        123 {c |}{res}          1        0.00       99.95
{txt}      123.5 {c |}{res}          1        0.00       99.95
{txt}        124 {c |}{res}          1        0.00       99.95
{txt}      124.5 {c |}{res}        132        0.01       99.96
{txt}        125 {c |}{res}          1        0.00       99.96
{txt}      125.5 {c |}{res}          1        0.00       99.96
{txt}        126 {c |}{res}          1        0.00       99.96
{txt}      126.5 {c |}{res}          1        0.00       99.96
{txt}        127 {c |}{res}         96        0.01       99.97
{txt}      127.5 {c |}{res}          1        0.00       99.97
{txt}        128 {c |}{res}          1        0.00       99.97
{txt}      128.5 {c |}{res}          1        0.00       99.97
{txt}        129 {c |}{res}          1        0.00       99.97
{txt}      129.5 {c |}{res}          1        0.00       99.97
{txt}        130 {c |}{res}          1        0.00       99.97
{txt}      130.5 {c |}{res}          1        0.00       99.97
{txt}        131 {c |}{res}          1        0.00       99.97
{txt}      131.5 {c |}{res}          1        0.00       99.97
{txt}        132 {c |}{res}         12        0.00       99.97
{txt}      132.5 {c |}{res}          1        0.00       99.97
{txt}        133 {c |}{res}          1        0.00       99.97
{txt}      133.5 {c |}{res}          1        0.00       99.97
{txt}        134 {c |}{res}          1        0.00       99.97
{txt}      134.5 {c |}{res}          1        0.00       99.97
{txt}        135 {c |}{res}          1        0.00       99.97
{txt}      135.5 {c |}{res}          1        0.00       99.97
{txt}        136 {c |}{res}          1        0.00       99.97
{txt}      136.5 {c |}{res}          1        0.00       99.97
{txt}        137 {c |}{res}          1        0.00       99.97
{txt}      137.5 {c |}{res}          1        0.00       99.97
{txt}        138 {c |}{res}          1        0.00       99.97
{txt}      138.5 {c |}{res}          1        0.00       99.97
{txt}        139 {c |}{res}          1        0.00       99.97
{txt}      139.5 {c |}{res}          1        0.00       99.97
{txt}        140 {c |}{res}          1        0.00       99.97
{txt}      140.5 {c |}{res}          1        0.00       99.97
{txt}        141 {c |}{res}          1        0.00       99.97
{txt}      141.5 {c |}{res}          1        0.00       99.97
{txt}        142 {c |}{res}          1        0.00       99.97
{txt}      142.5 {c |}{res}          1        0.00       99.97
{txt}        143 {c |}{res}         48        0.00       99.98
{txt}      143.5 {c |}{res}          1        0.00       99.98
{txt}        144 {c |}{res}          1        0.00       99.98
{txt}      144.5 {c |}{res}          1        0.00       99.98
{txt}        145 {c |}{res}          1        0.00       99.98
{txt}      145.5 {c |}{res}          1        0.00       99.98
{txt}        146 {c |}{res}          1        0.00       99.98
{txt}      146.5 {c |}{res}          1        0.00       99.98
{txt}        147 {c |}{res}          1        0.00       99.98
{txt}      147.5 {c |}{res}          1        0.00       99.98
{txt}        148 {c |}{res}          1        0.00       99.98
{txt}      148.5 {c |}{res}          1        0.00       99.98
{txt}        149 {c |}{res}          1        0.00       99.98
{txt}      149.5 {c |}{res}          1        0.00       99.98
{txt}        150 {c |}{res}          1        0.00       99.98
{txt}      150.5 {c |}{res}          1        0.00       99.98
{txt}        151 {c |}{res}          1        0.00       99.98
{txt}      151.5 {c |}{res}          1        0.00       99.98
{txt}        152 {c |}{res}          1        0.00       99.98
{txt}      152.5 {c |}{res}          1        0.00       99.98
{txt}        153 {c |}{res}          1        0.00       99.98
{txt}      153.5 {c |}{res}          1        0.00       99.98
{txt}        154 {c |}{res}          1        0.00       99.98
{txt}      154.5 {c |}{res}          1        0.00       99.98
{txt}        155 {c |}{res}          1        0.00       99.98
{txt}      155.5 {c |}{res}          1        0.00       99.98
{txt}        156 {c |}{res}          1        0.00       99.98
{txt}      156.5 {c |}{res}          1        0.00       99.98
{txt}        157 {c |}{res}          1        0.00       99.98
{txt}      157.5 {c |}{res}          1        0.00       99.98
{txt}        158 {c |}{res}          1        0.00       99.98
{txt}      158.5 {c |}{res}          1        0.00       99.98
{txt}        159 {c |}{res}          1        0.00       99.98
{txt}      159.5 {c |}{res}          1        0.00       99.98
{txt}        160 {c |}{res}          1        0.00       99.98
{txt}      160.5 {c |}{res}          1        0.00       99.98
{txt}        161 {c |}{res}          1        0.00       99.98
{txt}      161.5 {c |}{res}          1        0.00       99.98
{txt}        162 {c |}{res}          1        0.00       99.98
{txt}      162.5 {c |}{res}          1        0.00       99.98
{txt}        163 {c |}{res}          1        0.00       99.98
{txt}      163.5 {c |}{res}          1        0.00       99.98
{txt}        164 {c |}{res}          1        0.00       99.98
{txt}      164.5 {c |}{res}          1        0.00       99.98
{txt}        165 {c |}{res}          1        0.00       99.98
{txt}      165.5 {c |}{res}          1        0.00       99.98
{txt}        166 {c |}{res}          1        0.00       99.98
{txt}      166.5 {c |}{res}          1        0.00       99.98
{txt}        167 {c |}{res}          1        0.00       99.98
{txt}      167.5 {c |}{res}          1        0.00       99.98
{txt}        168 {c |}{res}          1        0.00       99.98
{txt}      168.5 {c |}{res}          1        0.00       99.98
{txt}        169 {c |}{res}          1        0.00       99.98
{txt}      169.5 {c |}{res}          1        0.00       99.98
{txt}        170 {c |}{res}          1        0.00       99.98
{txt}      170.5 {c |}{res}          1        0.00       99.98
{txt}        171 {c |}{res}          1        0.00       99.98
{txt}      171.5 {c |}{res}          1        0.00       99.98
{txt}        172 {c |}{res}          1        0.00       99.98
{txt}      172.5 {c |}{res}          1        0.00       99.98
{txt}        173 {c |}{res}          1        0.00       99.98
{txt}      173.5 {c |}{res}          1        0.00       99.98
{txt}        174 {c |}{res}          1        0.00       99.98
{txt}      174.5 {c |}{res}          1        0.00       99.98
{txt}        175 {c |}{res}          1        0.00       99.98
{txt}      175.5 {c |}{res}          1        0.00       99.98
{txt}        176 {c |}{res}          1        0.00       99.98
{txt}      176.5 {c |}{res}          1        0.00       99.98
{txt}        177 {c |}{res}          1        0.00       99.98
{txt}      177.5 {c |}{res}          1        0.00       99.98
{txt}        178 {c |}{res}          1        0.00       99.98
{txt}      178.5 {c |}{res}          1        0.00       99.98
{txt}        179 {c |}{res}          1        0.00       99.98
{txt}      179.5 {c |}{res}          1        0.00       99.98
{txt}        180 {c |}{res}          1        0.00       99.98
{txt}      180.5 {c |}{res}          1        0.00       99.98
{txt}        181 {c |}{res}          1        0.00       99.98
{txt}      181.5 {c |}{res}          1        0.00       99.98
{txt}        182 {c |}{res}          1        0.00       99.98
{txt}      182.5 {c |}{res}          1        0.00       99.98
{txt}        183 {c |}{res}          1        0.00       99.98
{txt}      183.5 {c |}{res}          1        0.00       99.98
{txt}        184 {c |}{res}          1        0.00       99.98
{txt}      184.5 {c |}{res}          1        0.00       99.98
{txt}        185 {c |}{res}          1        0.00       99.98
{txt}      185.5 {c |}{res}          1        0.00       99.98
{txt}        186 {c |}{res}          1        0.00       99.98
{txt}      186.5 {c |}{res}          1        0.00       99.98
{txt}        187 {c |}{res}          1        0.00       99.98
{txt}      187.5 {c |}{res}          1        0.00       99.98
{txt}        188 {c |}{res}          1        0.00       99.98
{txt}      188.5 {c |}{res}          1        0.00       99.98
{txt}        189 {c |}{res}          1        0.00       99.98
{txt}      189.5 {c |}{res}          1        0.00       99.98
{txt}        190 {c |}{res}          1        0.00       99.98
{txt}      190.5 {c |}{res}          1        0.00       99.98
{txt}        191 {c |}{res}          1        0.00       99.98
{txt}      191.5 {c |}{res}          1        0.00       99.98
{txt}        192 {c |}{res}          1        0.00       99.98
{txt}      192.5 {c |}{res}          1        0.00       99.98
{txt}        193 {c |}{res}          1        0.00       99.98
{txt}      193.5 {c |}{res}          1        0.00       99.98
{txt}        194 {c |}{res}          1        0.00       99.98
{txt}      194.5 {c |}{res}          1        0.00       99.98
{txt}        195 {c |}{res}          1        0.00       99.98
{txt}      195.5 {c |}{res}          1        0.00       99.98
{txt}        196 {c |}{res}          1        0.00       99.98
{txt}      196.5 {c |}{res}          1        0.00       99.98
{txt}        197 {c |}{res}          1        0.00       99.98
{txt}      197.5 {c |}{res}          1        0.00       99.98
{txt}        198 {c |}{res}          1        0.00       99.98
{txt}      198.5 {c |}{res}          1        0.00       99.98
{txt}        199 {c |}{res}          1        0.00       99.98
{txt}      199.5 {c |}{res}          1        0.00       99.99
{txt}        200 {c |}{res}          1        0.00       99.99
{txt}      200.5 {c |}{res}          1        0.00       99.99
{txt}        201 {c |}{res}          1        0.00       99.99
{txt}      201.5 {c |}{res}          1        0.00       99.99
{txt}        202 {c |}{res}          1        0.00       99.99
{txt}      202.5 {c |}{res}          1        0.00       99.99
{txt}        203 {c |}{res}          1        0.00       99.99
{txt}      203.5 {c |}{res}          1        0.00       99.99
{txt}        204 {c |}{res}          1        0.00       99.99
{txt}      204.5 {c |}{res}          1        0.00       99.99
{txt}        205 {c |}{res}          1        0.00       99.99
{txt}      205.5 {c |}{res}          1        0.00       99.99
{txt}        206 {c |}{res}          1        0.00       99.99
{txt}      206.5 {c |}{res}          1        0.00       99.99
{txt}        207 {c |}{res}          1        0.00       99.99
{txt}      207.5 {c |}{res}          1        0.00       99.99
{txt}        208 {c |}{res}          1        0.00       99.99
{txt}      208.5 {c |}{res}          1        0.00       99.99
{txt}        209 {c |}{res}          1        0.00       99.99
{txt}      209.5 {c |}{res}          1        0.00       99.99
{txt}        210 {c |}{res}          1        0.00       99.99
{txt}      210.5 {c |}{res}          1        0.00       99.99
{txt}        211 {c |}{res}          1        0.00       99.99
{txt}      211.5 {c |}{res}          1        0.00       99.99
{txt}        212 {c |}{res}          1        0.00       99.99
{txt}      212.5 {c |}{res}          1        0.00       99.99
{txt}        213 {c |}{res}          1        0.00       99.99
{txt}      213.5 {c |}{res}          1        0.00       99.99
{txt}        214 {c |}{res}          1        0.00       99.99
{txt}      214.5 {c |}{res}          1        0.00       99.99
{txt}        215 {c |}{res}          1        0.00       99.99
{txt}      215.5 {c |}{res}          1        0.00       99.99
{txt}        216 {c |}{res}          1        0.00       99.99
{txt}      216.5 {c |}{res}          1        0.00       99.99
{txt}        217 {c |}{res}          1        0.00       99.99
{txt}      217.5 {c |}{res}          1        0.00       99.99
{txt}        218 {c |}{res}          1        0.00       99.99
{txt}      218.5 {c |}{res}          1        0.00       99.99
{txt}        219 {c |}{res}          1        0.00       99.99
{txt}      219.5 {c |}{res}          1        0.00       99.99
{txt}        220 {c |}{res}          1        0.00       99.99
{txt}      220.5 {c |}{res}          1        0.00       99.99
{txt}        221 {c |}{res}          1        0.00       99.99
{txt}      221.5 {c |}{res}          1        0.00       99.99
{txt}        222 {c |}{res}          1        0.00       99.99
{txt}      222.5 {c |}{res}          1        0.00       99.99
{txt}        223 {c |}{res}          1        0.00       99.99
{txt}      223.5 {c |}{res}          1        0.00       99.99
{txt}        224 {c |}{res}          1        0.00       99.99
{txt}      224.5 {c |}{res}          1        0.00       99.99
{txt}        225 {c |}{res}          1        0.00       99.99
{txt}      225.5 {c |}{res}          1        0.00       99.99
{txt}        226 {c |}{res}          1        0.00       99.99
{txt}      226.5 {c |}{res}          1        0.00       99.99
{txt}        227 {c |}{res}          1        0.00       99.99
{txt}      227.5 {c |}{res}          1        0.00       99.99
{txt}        228 {c |}{res}          1        0.00       99.99
{txt}      228.5 {c |}{res}          1        0.00       99.99
{txt}        229 {c |}{res}          1        0.00       99.99
{txt}      229.5 {c |}{res}          1        0.00       99.99
{txt}        230 {c |}{res}          1        0.00       99.99
{txt}      230.5 {c |}{res}          1        0.00       99.99
{txt}        231 {c |}{res}          1        0.00       99.99
{txt}      231.5 {c |}{res}          1        0.00       99.99
{txt}        232 {c |}{res}          1        0.00       99.99
{txt}      232.5 {c |}{res}          1        0.00       99.99
{txt}        233 {c |}{res}          1        0.00       99.99
{txt}      233.5 {c |}{res}          1        0.00       99.99
{txt}        234 {c |}{res}          1        0.00       99.99
{txt}      234.5 {c |}{res}          1        0.00       99.99
{txt}        235 {c |}{res}          1        0.00       99.99
{txt}      235.5 {c |}{res}          1        0.00       99.99
{txt}        236 {c |}{res}          1        0.00       99.99
{txt}      236.5 {c |}{res}          1        0.00       99.99
{txt}        237 {c |}{res}          1        0.00       99.99
{txt}      237.5 {c |}{res}          1        0.00       99.99
{txt}        238 {c |}{res}          1        0.00       99.99
{txt}      238.5 {c |}{res}          1        0.00       99.99
{txt}        239 {c |}{res}          1        0.00       99.99
{txt}      239.5 {c |}{res}          1        0.00       99.99
{txt}        240 {c |}{res}          1        0.00       99.99
{txt}      240.5 {c |}{res}          1        0.00       99.99
{txt}        241 {c |}{res}          1        0.00       99.99
{txt}      241.5 {c |}{res}          1        0.00       99.99
{txt}        242 {c |}{res}          1        0.00       99.99
{txt}      242.5 {c |}{res}          1        0.00       99.99
{txt}        243 {c |}{res}          1        0.00       99.99
{txt}      243.5 {c |}{res}          1        0.00       99.99
{txt}        244 {c |}{res}          1        0.00       99.99
{txt}      244.5 {c |}{res}          1        0.00       99.99
{txt}        245 {c |}{res}          1        0.00       99.99
{txt}      245.5 {c |}{res}          1        0.00       99.99
{txt}        246 {c |}{res}          1        0.00       99.99
{txt}      246.5 {c |}{res}          1        0.00       99.99
{txt}        247 {c |}{res}          1        0.00       99.99
{txt}      247.5 {c |}{res}          1        0.00       99.99
{txt}        248 {c |}{res}          1        0.00       99.99
{txt}      248.5 {c |}{res}          1        0.00       99.99
{txt}        249 {c |}{res}          1        0.00       99.99
{txt}      249.5 {c |}{res}          1        0.00       99.99
{txt}        250 {c |}{res}          1        0.00       99.99
{txt}      250.5 {c |}{res}          1        0.00       99.99
{txt}        251 {c |}{res}          1        0.00       99.99
{txt}      251.5 {c |}{res}          1        0.00       99.99
{txt}        252 {c |}{res}          1        0.00       99.99
{txt}      252.5 {c |}{res}          1        0.00       99.99
{txt}        253 {c |}{res}          1        0.00       99.99
{txt}      253.5 {c |}{res}          1        0.00       99.99
{txt}        254 {c |}{res}          1        0.00       99.99
{txt}      254.5 {c |}{res}          1        0.00       99.99
{txt}        255 {c |}{res}          1        0.00       99.99
{txt}      255.5 {c |}{res}          1        0.00       99.99
{txt}        256 {c |}{res}          1        0.00       99.99
{txt}      256.5 {c |}{res}          1        0.00       99.99
{txt}        257 {c |}{res}          1        0.00       99.99
{txt}      257.5 {c |}{res}          1        0.00       99.99
{txt}        258 {c |}{res}          1        0.00       99.99
{txt}      258.5 {c |}{res}          1        0.00       99.99
{txt}        259 {c |}{res}          1        0.00      100.00
{txt}      259.5 {c |}{res}          1        0.00      100.00
{txt}        260 {c |}{res}          1        0.00      100.00
{txt}      260.5 {c |}{res}          1        0.00      100.00
{txt}        261 {c |}{res}          1        0.00      100.00
{txt}      261.5 {c |}{res}          1        0.00      100.00
{txt}        262 {c |}{res}          1        0.00      100.00
{txt}      262.5 {c |}{res}          1        0.00      100.00
{txt}        263 {c |}{res}          1        0.00      100.00
{txt}      263.5 {c |}{res}          1        0.00      100.00
{txt}        264 {c |}{res}          1        0.00      100.00
{txt}      264.5 {c |}{res}          1        0.00      100.00
{txt}        265 {c |}{res}          1        0.00      100.00
{txt}      265.5 {c |}{res}          1        0.00      100.00
{txt}        266 {c |}{res}          1        0.00      100.00
{txt}      266.5 {c |}{res}          1        0.00      100.00
{txt}        267 {c |}{res}          1        0.00      100.00
{txt}      267.5 {c |}{res}          1        0.00      100.00
{txt}        268 {c |}{res}          1        0.00      100.00
{txt}      268.5 {c |}{res}          1        0.00      100.00
{txt}        269 {c |}{res}          1        0.00      100.00
{txt}      269.5 {c |}{res}          1        0.00      100.00
{txt}        270 {c |}{res}          1        0.00      100.00
{txt}      270.5 {c |}{res}          1        0.00      100.00
{txt}        271 {c |}{res}         36        0.00      100.00
{txt}{hline 12}{c +}{hline 35}
      Total {c |}{res}  1,190,066      100.00
{txt}
{com}. replace eei_bin = eei_binf if added_eei == 1  // re-assigned values for expanded grid.   
{txt}(482 real changes made)

{com}. tab eei_bin                                                               // 13.5 to 143. 

     {txt}EEI in {c |}
   0.5-unit {c |}
       bins {c |}      Freq.     Percent        Cum.
{hline 12}{c +}{hline 35}
       13.5 {c |}{res}        164        0.03        0.03
{txt}         14 {c |}{res}          1        0.00        0.03
{txt}       14.5 {c |}{res}          1        0.00        0.03
{txt}         15 {c |}{res}          1        0.00        0.03
{txt}       15.5 {c |}{res}          1        0.00        0.03
{txt}         16 {c |}{res}          2        0.00        0.03
{txt}       16.5 {c |}{res}          1        0.00        0.03
{txt}         17 {c |}{res}          1        0.00        0.03
{txt}       17.5 {c |}{res}         64        0.01        0.05
{txt}         18 {c |}{res}        178        0.04        0.08
{txt}       18.5 {c |}{res}          1        0.00        0.08
{txt}         19 {c |}{res}         14        0.00        0.09
{txt}       19.5 {c |}{res}          1        0.00        0.09
{txt}         20 {c |}{res}          1        0.00        0.09
{txt}       20.5 {c |}{res}        519        0.10        0.19
{txt}         21 {c |}{res}          1        0.00        0.19
{txt}       21.5 {c |}{res}          1        0.00        0.19
{txt}         22 {c |}{res}      1,034        0.21        0.40
{txt}       22.5 {c |}{res}      1,478        0.30        0.69
{txt}         23 {c |}{res}          1        0.00        0.69
{txt}       23.5 {c |}{res}          1        0.00        0.69
{txt}         24 {c |}{res}          1        0.00        0.69
{txt}       24.5 {c |}{res}          1        0.00        0.69
{txt}         25 {c |}{res}        100        0.02        0.71
{txt}       25.5 {c |}{res}          1        0.00        0.71
{txt}         26 {c |}{res}         51        0.01        0.72
{txt}       26.5 {c |}{res}        316        0.06        0.79
{txt}         27 {c |}{res}      3,330        0.67        1.45
{txt}       27.5 {c |}{res}        330        0.07        1.52
{txt}         28 {c |}{res}         74        0.01        1.53
{txt}       28.5 {c |}{res}         85        0.02        1.55
{txt}         29 {c |}{res}         37        0.01        1.56
{txt}       29.5 {c |}{res}      1,016        0.20        1.76
{txt}         30 {c |}{res}          1        0.00        1.76
{txt}       30.5 {c |}{res}         27        0.01        1.77
{txt}         31 {c |}{res}          1        0.00        1.77
{txt}       31.5 {c |}{res}      3,597        0.72        2.48
{txt}         32 {c |}{res}     16,063        3.21        5.69
{txt}       32.5 {c |}{res}        617        0.12        5.82
{txt}         33 {c |}{res}        417        0.08        5.90
{txt}       33.5 {c |}{res}        109        0.02        5.92
{txt}         34 {c |}{res}          1        0.00        5.92
{txt}       34.5 {c |}{res}        133        0.03        5.95
{txt}         35 {c |}{res}        562        0.11        6.06
{txt}       35.5 {c |}{res}        734        0.15        6.21
{txt}         36 {c |}{res}      5,865        1.17        7.38
{txt}       36.5 {c |}{res}      5,964        1.19        8.57
{txt}         37 {c |}{res}        433        0.09        8.66
{txt}       37.5 {c |}{res}      1,416        0.28        8.94
{txt}         38 {c |}{res}      2,838        0.57        9.51
{txt}       38.5 {c |}{res}      2,595        0.52       10.02
{txt}         39 {c |}{res}      1,561        0.31       10.34
{txt}       39.5 {c |}{res}      4,117        0.82       11.16
{txt}         40 {c |}{res}        917        0.18       11.34
{txt}       40.5 {c |}{res}      2,748        0.55       11.89
{txt}         41 {c |}{res}      9,071        1.81       13.70
{txt}       41.5 {c |}{res}      1,730        0.35       14.05
{txt}         42 {c |}{res}      8,764        1.75       15.80
{txt}       42.5 {c |}{res}      5,028        1.00       16.80
{txt}         43 {c |}{res}     10,428        2.08       18.89
{txt}       43.5 {c |}{res}      7,644        1.53       20.41
{txt}         44 {c |}{res}     21,741        4.34       24.76
{txt}       44.5 {c |}{res}     24,172        4.83       29.59
{txt}         45 {c |}{res}     18,580        3.71       33.30
{txt}       45.5 {c |}{res}     51,072       10.20       43.50
{txt}         46 {c |}{res}      1,495        0.30       43.80
{txt}       46.5 {c |}{res}      2,258        0.45       44.25
{txt}         47 {c |}{res}      1,850        0.37       44.62
{txt}       47.5 {c |}{res}      1,923        0.38       45.00
{txt}         48 {c |}{res}      1,874        0.37       45.38
{txt}       48.5 {c |}{res}      2,360        0.47       45.85
{txt}         49 {c |}{res}     10,828        2.16       48.01
{txt}       49.5 {c |}{res}      2,242        0.45       48.46
{txt}         50 {c |}{res}      7,346        1.47       49.93
{txt}       50.5 {c |}{res}     24,178        4.83       54.76
{txt}         51 {c |}{res}      8,376        1.67       56.43
{txt}       51.5 {c |}{res}     32,455        6.48       62.91
{txt}         52 {c |}{res}      6,681        1.33       64.25
{txt}       52.5 {c |}{res}        656        0.13       64.38
{txt}         53 {c |}{res}      1,756        0.35       64.73
{txt}       53.5 {c |}{res}      3,024        0.60       65.34
{txt}         54 {c |}{res}      1,206        0.24       65.58
{txt}       54.5 {c |}{res}      3,122        0.62       66.20
{txt}         55 {c |}{res}     11,874        2.37       68.57
{txt}       55.5 {c |}{res}      3,884        0.78       69.35
{txt}         56 {c |}{res}      5,469        1.09       70.44
{txt}       56.5 {c |}{res}      9,163        1.83       72.27
{txt}         57 {c |}{res}      5,348        1.07       73.34
{txt}       57.5 {c |}{res}     14,117        2.82       76.16
{txt}         58 {c |}{res}     20,315        4.06       80.22
{txt}       58.5 {c |}{res}     29,394        5.87       86.09
{txt}         59 {c |}{res}     10,158        2.03       88.12
{txt}       59.5 {c |}{res}      3,278        0.65       88.77
{txt}         60 {c |}{res}        733        0.15       88.92
{txt}       60.5 {c |}{res}      1,621        0.32       89.24
{txt}         61 {c |}{res}     10,082        2.01       91.26
{txt}       61.5 {c |}{res}        853        0.17       91.43
{txt}         62 {c |}{res}        397        0.08       91.51
{txt}       62.5 {c |}{res}      6,064        1.21       92.72
{txt}         63 {c |}{res}        746        0.15       92.87
{txt}       63.5 {c |}{res}      2,451        0.49       93.36
{txt}         64 {c |}{res}        578        0.12       93.47
{txt}       64.5 {c |}{res}        746        0.15       93.62
{txt}         65 {c |}{res}      3,103        0.62       94.24
{txt}       65.5 {c |}{res}        637        0.13       94.37
{txt}         66 {c |}{res}      5,463        1.09       95.46
{txt}       66.5 {c |}{res}          1        0.00       95.46
{txt}         67 {c |}{res}      3,254        0.65       96.11
{txt}       67.5 {c |}{res}      2,340        0.47       96.58
{txt}         68 {c |}{res}      4,574        0.91       97.49
{txt}       68.5 {c |}{res}        984        0.20       97.69
{txt}         69 {c |}{res}        217        0.04       97.73
{txt}       69.5 {c |}{res}      1,260        0.25       97.98
{txt}         70 {c |}{res}         61        0.01       98.00
{txt}       70.5 {c |}{res}        276        0.06       98.05
{txt}         71 {c |}{res}        445        0.09       98.14
{txt}       71.5 {c |}{res}        481        0.10       98.24
{txt}         72 {c |}{res}        241        0.05       98.28
{txt}       72.5 {c |}{res}      1,620        0.32       98.61
{txt}         73 {c |}{res}         86        0.02       98.62
{txt}       73.5 {c |}{res}        433        0.09       98.71
{txt}         74 {c |}{res}          1        0.00       98.71
{txt}       74.5 {c |}{res}        240        0.05       98.76
{txt}         75 {c |}{res}        673        0.13       98.89
{txt}       75.5 {c |}{res}         85        0.02       98.91
{txt}         76 {c |}{res}        157        0.03       98.94
{txt}       76.5 {c |}{res}        576        0.12       99.06
{txt}         77 {c |}{res}        206        0.04       99.10
{txt}       77.5 {c |}{res}          1        0.00       99.10
{txt}         78 {c |}{res}        157        0.03       99.13
{txt}       78.5 {c |}{res}         85        0.02       99.15
{txt}         79 {c |}{res}         97        0.02       99.17
{txt}       79.5 {c |}{res}        157        0.03       99.20
{txt}         80 {c |}{res}          1        0.00       99.20
{txt}       80.5 {c |}{res}          1        0.00       99.20
{txt}         81 {c |}{res}          1        0.00       99.20
{txt}       81.5 {c |}{res}          1        0.00       99.20
{txt}         82 {c |}{res}          1        0.00       99.20
{txt}       82.5 {c |}{res}          1        0.00       99.20
{txt}         83 {c |}{res}          1        0.00       99.20
{txt}       83.5 {c |}{res}         13        0.00       99.20
{txt}         84 {c |}{res}          1        0.00       99.20
{txt}       84.5 {c |}{res}          1        0.00       99.20
{txt}         85 {c |}{res}        157        0.03       99.23
{txt}       85.5 {c |}{res}          1        0.00       99.23
{txt}         86 {c |}{res}         62        0.01       99.25
{txt}       86.5 {c |}{res}          1        0.00       99.25
{txt}         87 {c |}{res}          1        0.00       99.25
{txt}       87.5 {c |}{res}          1        0.00       99.25
{txt}         88 {c |}{res}          1        0.00       99.25
{txt}       88.5 {c |}{res}        121        0.02       99.27
{txt}         89 {c |}{res}        265        0.05       99.32
{txt}       89.5 {c |}{res}          1        0.00       99.32
{txt}         90 {c |}{res}          1        0.00       99.32
{txt}       90.5 {c |}{res}          1        0.00       99.32
{txt}         91 {c |}{res}          1        0.00       99.32
{txt}       91.5 {c |}{res}         97        0.02       99.34
{txt}         92 {c |}{res}          1        0.00       99.34
{txt}       92.5 {c |}{res}         36        0.01       99.35
{txt}         93 {c |}{res}          1        0.00       99.35
{txt}       93.5 {c |}{res}          1        0.00       99.35
{txt}         94 {c |}{res}          1        0.00       99.35
{txt}       94.5 {c |}{res}          1        0.00       99.35
{txt}         95 {c |}{res}          1        0.00       99.35
{txt}       95.5 {c |}{res}          1        0.00       99.35
{txt}         96 {c |}{res}         14        0.00       99.36
{txt}       96.5 {c |}{res}          1        0.00       99.36
{txt}         97 {c |}{res}          1        0.00       99.36
{txt}       97.5 {c |}{res}          1        0.00       99.36
{txt}         98 {c |}{res}          1        0.00       99.36
{txt}       98.5 {c |}{res}          1        0.00       99.36
{txt}         99 {c |}{res}          1        0.00       99.36
{txt}       99.5 {c |}{res}         25        0.00       99.36
{txt}        100 {c |}{res}        652        0.13       99.49
{txt}      100.5 {c |}{res}          1        0.00       99.49
{txt}        101 {c |}{res}          1        0.00       99.49
{txt}      101.5 {c |}{res}          1        0.00       99.49
{txt}        102 {c |}{res}        133        0.03       99.52
{txt}      102.5 {c |}{res}          1        0.00       99.52
{txt}        103 {c |}{res}          1        0.00       99.52
{txt}      103.5 {c |}{res}        145        0.03       99.55
{txt}        104 {c |}{res}          1        0.00       99.55
{txt}      104.5 {c |}{res}          1        0.00       99.55
{txt}        105 {c |}{res}        217        0.04       99.59
{txt}      105.5 {c |}{res}          1        0.00       99.59
{txt}        106 {c |}{res}          1        0.00       99.59
{txt}      106.5 {c |}{res}          1        0.00       99.59
{txt}        107 {c |}{res}          1        0.00       99.59
{txt}      107.5 {c |}{res}          1        0.00       99.59
{txt}        108 {c |}{res}        145        0.03       99.62
{txt}      108.5 {c |}{res}          1        0.00       99.62
{txt}        109 {c |}{res}          1        0.00       99.62
{txt}      109.5 {c |}{res}          1        0.00       99.62
{txt}        110 {c |}{res}          1        0.00       99.62
{txt}      110.5 {c |}{res}          1        0.00       99.62
{txt}        111 {c |}{res}        769        0.15       99.78
{txt}      111.5 {c |}{res}          1        0.00       99.78
{txt}        112 {c |}{res}          1        0.00       99.78
{txt}      112.5 {c |}{res}          1        0.00       99.78
{txt}        113 {c |}{res}          1        0.00       99.78
{txt}      113.5 {c |}{res}          1        0.00       99.78
{txt}        114 {c |}{res}        181        0.04       99.81
{txt}      114.5 {c |}{res}          1        0.00       99.81
{txt}        115 {c |}{res}          1        0.00       99.81
{txt}      115.5 {c |}{res}          1        0.00       99.81
{txt}        116 {c |}{res}          1        0.00       99.81
{txt}      116.5 {c |}{res}          1        0.00       99.81
{txt}        117 {c |}{res}          1        0.00       99.82
{txt}      117.5 {c |}{res}          1        0.00       99.82
{txt}        118 {c |}{res}          1        0.00       99.82
{txt}      118.5 {c |}{res}          1        0.00       99.82
{txt}        119 {c |}{res}          1        0.00       99.82
{txt}      119.5 {c |}{res}          1        0.00       99.82
{txt}        120 {c |}{res}          1        0.00       99.82
{txt}      120.5 {c |}{res}        216        0.04       99.86
{txt}        121 {c |}{res}          1        0.00       99.86
{txt}      121.5 {c |}{res}          1        0.00       99.86
{txt}        122 {c |}{res}         85        0.02       99.88
{txt}      122.5 {c |}{res}          1        0.00       99.88
{txt}        123 {c |}{res}          1        0.00       99.88
{txt}      123.5 {c |}{res}          1        0.00       99.88
{txt}        124 {c |}{res}          1        0.00       99.88
{txt}      124.5 {c |}{res}        132        0.03       99.90
{txt}        125 {c |}{res}          1        0.00       99.90
{txt}      125.5 {c |}{res}          1        0.00       99.90
{txt}        126 {c |}{res}          1        0.00       99.90
{txt}      126.5 {c |}{res}          1        0.00       99.90
{txt}        127 {c |}{res}         96        0.02       99.92
{txt}      127.5 {c |}{res}          1        0.00       99.92
{txt}        128 {c |}{res}          1        0.00       99.92
{txt}      128.5 {c |}{res}          1        0.00       99.92
{txt}        129 {c |}{res}          1        0.00       99.92
{txt}      129.5 {c |}{res}          1        0.00       99.92
{txt}        130 {c |}{res}          1        0.00       99.93
{txt}      130.5 {c |}{res}          1        0.00       99.93
{txt}        131 {c |}{res}          1        0.00       99.93
{txt}      131.5 {c |}{res}          1        0.00       99.93
{txt}        132 {c |}{res}         12        0.00       99.93
{txt}      132.5 {c |}{res}          1        0.00       99.93
{txt}        133 {c |}{res}          1        0.00       99.93
{txt}      133.5 {c |}{res}          1        0.00       99.93
{txt}        134 {c |}{res}          1        0.00       99.93
{txt}      134.5 {c |}{res}          1        0.00       99.93
{txt}        135 {c |}{res}          1        0.00       99.93
{txt}      135.5 {c |}{res}          1        0.00       99.93
{txt}        136 {c |}{res}          1        0.00       99.93
{txt}      136.5 {c |}{res}          1        0.00       99.93
{txt}        137 {c |}{res}          1        0.00       99.93
{txt}      137.5 {c |}{res}          1        0.00       99.93
{txt}        138 {c |}{res}          1        0.00       99.93
{txt}      138.5 {c |}{res}          1        0.00       99.93
{txt}        139 {c |}{res}          1        0.00       99.93
{txt}      139.5 {c |}{res}          1        0.00       99.93
{txt}        140 {c |}{res}          1        0.00       99.93
{txt}      140.5 {c |}{res}          1        0.00       99.93
{txt}        141 {c |}{res}          1        0.00       99.93
{txt}      141.5 {c |}{res}          1        0.00       99.93
{txt}        142 {c |}{res}          1        0.00       99.93
{txt}      142.5 {c |}{res}          1        0.00       99.93
{txt}        143 {c |}{res}         48        0.01       99.94
{txt}      143.5 {c |}{res}          1        0.00       99.94
{txt}        144 {c |}{res}          1        0.00       99.94
{txt}      144.5 {c |}{res}          1        0.00       99.94
{txt}        145 {c |}{res}          1        0.00       99.94
{txt}      145.5 {c |}{res}          1        0.00       99.94
{txt}        146 {c |}{res}          1        0.00       99.94
{txt}      146.5 {c |}{res}          1        0.00       99.94
{txt}        147 {c |}{res}          1        0.00       99.94
{txt}      147.5 {c |}{res}          1        0.00       99.94
{txt}        148 {c |}{res}          1        0.00       99.94
{txt}      148.5 {c |}{res}          1        0.00       99.94
{txt}        149 {c |}{res}          1        0.00       99.94
{txt}      149.5 {c |}{res}          1        0.00       99.94
{txt}        150 {c |}{res}          1        0.00       99.94
{txt}      150.5 {c |}{res}          1        0.00       99.94
{txt}        151 {c |}{res}          1        0.00       99.95
{txt}      151.5 {c |}{res}          1        0.00       99.95
{txt}        152 {c |}{res}          1        0.00       99.95
{txt}      152.5 {c |}{res}          1        0.00       99.95
{txt}        153 {c |}{res}          1        0.00       99.95
{txt}      153.5 {c |}{res}          1        0.00       99.95
{txt}        154 {c |}{res}          1        0.00       99.95
{txt}      154.5 {c |}{res}          1        0.00       99.95
{txt}        155 {c |}{res}          1        0.00       99.95
{txt}      155.5 {c |}{res}          1        0.00       99.95
{txt}        156 {c |}{res}          1        0.00       99.95
{txt}      156.5 {c |}{res}          1        0.00       99.95
{txt}        157 {c |}{res}          1        0.00       99.95
{txt}      157.5 {c |}{res}          1        0.00       99.95
{txt}        158 {c |}{res}          1        0.00       99.95
{txt}      158.5 {c |}{res}          1        0.00       99.95
{txt}        159 {c |}{res}          1        0.00       99.95
{txt}      159.5 {c |}{res}          1        0.00       99.95
{txt}        160 {c |}{res}          1        0.00       99.95
{txt}      160.5 {c |}{res}          1        0.00       99.95
{txt}        161 {c |}{res}          1        0.00       99.95
{txt}      161.5 {c |}{res}          1        0.00       99.95
{txt}        162 {c |}{res}          1        0.00       99.95
{txt}      162.5 {c |}{res}          1        0.00       99.95
{txt}        163 {c |}{res}          1        0.00       99.95
{txt}      163.5 {c |}{res}          1        0.00       99.95
{txt}        164 {c |}{res}          1        0.00       99.95
{txt}      164.5 {c |}{res}          1        0.00       99.95
{txt}        165 {c |}{res}          1        0.00       99.95
{txt}      165.5 {c |}{res}          1        0.00       99.95
{txt}        166 {c |}{res}          1        0.00       99.95
{txt}      166.5 {c |}{res}          1        0.00       99.95
{txt}        167 {c |}{res}          1        0.00       99.95
{txt}      167.5 {c |}{res}          1        0.00       99.95
{txt}        168 {c |}{res}          1        0.00       99.95
{txt}      168.5 {c |}{res}          1        0.00       99.95
{txt}        169 {c |}{res}          1        0.00       99.95
{txt}      169.5 {c |}{res}          1        0.00       99.95
{txt}        170 {c |}{res}          1        0.00       99.95
{txt}      170.5 {c |}{res}          1        0.00       99.95
{txt}        171 {c |}{res}          1        0.00       99.95
{txt}      171.5 {c |}{res}          1        0.00       99.95
{txt}        172 {c |}{res}          1        0.00       99.95
{txt}      172.5 {c |}{res}          1        0.00       99.95
{txt}        173 {c |}{res}          1        0.00       99.95
{txt}      173.5 {c |}{res}          1        0.00       99.95
{txt}        174 {c |}{res}          1        0.00       99.95
{txt}      174.5 {c |}{res}          1        0.00       99.95
{txt}        175 {c |}{res}          1        0.00       99.95
{txt}      175.5 {c |}{res}          1        0.00       99.95
{txt}        176 {c |}{res}          1        0.00       99.96
{txt}      176.5 {c |}{res}          1        0.00       99.96
{txt}        177 {c |}{res}          1        0.00       99.96
{txt}      177.5 {c |}{res}          1        0.00       99.96
{txt}        178 {c |}{res}          1        0.00       99.96
{txt}      178.5 {c |}{res}          1        0.00       99.96
{txt}        179 {c |}{res}          1        0.00       99.96
{txt}      179.5 {c |}{res}          1        0.00       99.96
{txt}        180 {c |}{res}          1        0.00       99.96
{txt}      180.5 {c |}{res}          1        0.00       99.96
{txt}        181 {c |}{res}          1        0.00       99.96
{txt}      181.5 {c |}{res}          1        0.00       99.96
{txt}        182 {c |}{res}          1        0.00       99.96
{txt}      182.5 {c |}{res}          1        0.00       99.96
{txt}        183 {c |}{res}          1        0.00       99.96
{txt}      183.5 {c |}{res}          1        0.00       99.96
{txt}        184 {c |}{res}          1        0.00       99.96
{txt}      184.5 {c |}{res}          1        0.00       99.96
{txt}        185 {c |}{res}          1        0.00       99.96
{txt}      185.5 {c |}{res}          1        0.00       99.96
{txt}        186 {c |}{res}          1        0.00       99.96
{txt}      186.5 {c |}{res}          1        0.00       99.96
{txt}        187 {c |}{res}          1        0.00       99.96
{txt}      187.5 {c |}{res}          1        0.00       99.96
{txt}        188 {c |}{res}          1        0.00       99.96
{txt}      188.5 {c |}{res}          1        0.00       99.96
{txt}        189 {c |}{res}          1        0.00       99.96
{txt}      189.5 {c |}{res}          1        0.00       99.96
{txt}        190 {c |}{res}          1        0.00       99.96
{txt}      190.5 {c |}{res}          1        0.00       99.96
{txt}        191 {c |}{res}          1        0.00       99.96
{txt}      191.5 {c |}{res}          1        0.00       99.96
{txt}        192 {c |}{res}          1        0.00       99.96
{txt}      192.5 {c |}{res}          1        0.00       99.96
{txt}        193 {c |}{res}          1        0.00       99.96
{txt}      193.5 {c |}{res}          1        0.00       99.96
{txt}        194 {c |}{res}          1        0.00       99.96
{txt}      194.5 {c |}{res}          1        0.00       99.96
{txt}        195 {c |}{res}          1        0.00       99.96
{txt}      195.5 {c |}{res}          1        0.00       99.96
{txt}        196 {c |}{res}          1        0.00       99.96
{txt}      196.5 {c |}{res}          1        0.00       99.96
{txt}        197 {c |}{res}          1        0.00       99.96
{txt}      197.5 {c |}{res}          1        0.00       99.96
{txt}        198 {c |}{res}          1        0.00       99.96
{txt}      198.5 {c |}{res}          1        0.00       99.96
{txt}        199 {c |}{res}          1        0.00       99.96
{txt}      199.5 {c |}{res}          1        0.00       99.96
{txt}        200 {c |}{res}          1        0.00       99.96
{txt}      200.5 {c |}{res}          1        0.00       99.96
{txt}        201 {c |}{res}          1        0.00       99.97
{txt}      201.5 {c |}{res}          1        0.00       99.97
{txt}        202 {c |}{res}          1        0.00       99.97
{txt}      202.5 {c |}{res}          1        0.00       99.97
{txt}        203 {c |}{res}          1        0.00       99.97
{txt}      203.5 {c |}{res}          1        0.00       99.97
{txt}        204 {c |}{res}          1        0.00       99.97
{txt}      204.5 {c |}{res}          1        0.00       99.97
{txt}        205 {c |}{res}          1        0.00       99.97
{txt}      205.5 {c |}{res}          1        0.00       99.97
{txt}        206 {c |}{res}          1        0.00       99.97
{txt}      206.5 {c |}{res}          1        0.00       99.97
{txt}        207 {c |}{res}          1        0.00       99.97
{txt}      207.5 {c |}{res}          1        0.00       99.97
{txt}        208 {c |}{res}          1        0.00       99.97
{txt}      208.5 {c |}{res}          1        0.00       99.97
{txt}        209 {c |}{res}          1        0.00       99.97
{txt}      209.5 {c |}{res}          1        0.00       99.97
{txt}        210 {c |}{res}          1        0.00       99.97
{txt}      210.5 {c |}{res}          1        0.00       99.97
{txt}        211 {c |}{res}          1        0.00       99.97
{txt}      211.5 {c |}{res}          1        0.00       99.97
{txt}        212 {c |}{res}          1        0.00       99.97
{txt}      212.5 {c |}{res}          1        0.00       99.97
{txt}        213 {c |}{res}          1        0.00       99.97
{txt}      213.5 {c |}{res}          1        0.00       99.97
{txt}        214 {c |}{res}          1        0.00       99.97
{txt}      214.5 {c |}{res}          1        0.00       99.97
{txt}        215 {c |}{res}          1        0.00       99.97
{txt}      215.5 {c |}{res}          1        0.00       99.97
{txt}        216 {c |}{res}          1        0.00       99.97
{txt}      216.5 {c |}{res}          1        0.00       99.97
{txt}        217 {c |}{res}          1        0.00       99.97
{txt}      217.5 {c |}{res}          1        0.00       99.97
{txt}        218 {c |}{res}          1        0.00       99.97
{txt}      218.5 {c |}{res}          1        0.00       99.97
{txt}        219 {c |}{res}          1        0.00       99.97
{txt}      219.5 {c |}{res}          1        0.00       99.97
{txt}        220 {c |}{res}          1        0.00       99.97
{txt}      220.5 {c |}{res}          1        0.00       99.97
{txt}        221 {c |}{res}          1        0.00       99.97
{txt}      221.5 {c |}{res}          1        0.00       99.97
{txt}        222 {c |}{res}          1        0.00       99.97
{txt}      222.5 {c |}{res}          1        0.00       99.97
{txt}        223 {c |}{res}          1        0.00       99.97
{txt}      223.5 {c |}{res}          1        0.00       99.97
{txt}        224 {c |}{res}          1        0.00       99.97
{txt}      224.5 {c |}{res}          1        0.00       99.97
{txt}        225 {c |}{res}          1        0.00       99.97
{txt}      225.5 {c |}{res}          1        0.00       99.97
{txt}        226 {c |}{res}          1        0.00       99.98
{txt}      226.5 {c |}{res}          1        0.00       99.98
{txt}        227 {c |}{res}          1        0.00       99.98
{txt}      227.5 {c |}{res}          1        0.00       99.98
{txt}        228 {c |}{res}          1        0.00       99.98
{txt}      228.5 {c |}{res}          1        0.00       99.98
{txt}        229 {c |}{res}          1        0.00       99.98
{txt}      229.5 {c |}{res}          1        0.00       99.98
{txt}        230 {c |}{res}          1        0.00       99.98
{txt}      230.5 {c |}{res}          1        0.00       99.98
{txt}        231 {c |}{res}          1        0.00       99.98
{txt}      231.5 {c |}{res}          1        0.00       99.98
{txt}        232 {c |}{res}          1        0.00       99.98
{txt}      232.5 {c |}{res}          1        0.00       99.98
{txt}        233 {c |}{res}          1        0.00       99.98
{txt}      233.5 {c |}{res}          1        0.00       99.98
{txt}        234 {c |}{res}          1        0.00       99.98
{txt}      234.5 {c |}{res}          1        0.00       99.98
{txt}        235 {c |}{res}          1        0.00       99.98
{txt}      235.5 {c |}{res}          1        0.00       99.98
{txt}        236 {c |}{res}          1        0.00       99.98
{txt}      236.5 {c |}{res}          1        0.00       99.98
{txt}        237 {c |}{res}          1        0.00       99.98
{txt}      237.5 {c |}{res}          1        0.00       99.98
{txt}        238 {c |}{res}          1        0.00       99.98
{txt}      238.5 {c |}{res}          1        0.00       99.98
{txt}        239 {c |}{res}          1        0.00       99.98
{txt}      239.5 {c |}{res}          1        0.00       99.98
{txt}        240 {c |}{res}          1        0.00       99.98
{txt}      240.5 {c |}{res}          1        0.00       99.98
{txt}        241 {c |}{res}          1        0.00       99.98
{txt}      241.5 {c |}{res}          1        0.00       99.98
{txt}        242 {c |}{res}          1        0.00       99.98
{txt}      242.5 {c |}{res}          1        0.00       99.98
{txt}        243 {c |}{res}          1        0.00       99.98
{txt}      243.5 {c |}{res}          1        0.00       99.98
{txt}        244 {c |}{res}          1        0.00       99.98
{txt}      244.5 {c |}{res}          1        0.00       99.98
{txt}        245 {c |}{res}          1        0.00       99.98
{txt}      245.5 {c |}{res}          1        0.00       99.98
{txt}        246 {c |}{res}          1        0.00       99.98
{txt}      246.5 {c |}{res}          1        0.00       99.98
{txt}        247 {c |}{res}          1        0.00       99.98
{txt}      247.5 {c |}{res}          1        0.00       99.98
{txt}        248 {c |}{res}          1        0.00       99.98
{txt}      248.5 {c |}{res}          1        0.00       99.98
{txt}        249 {c |}{res}          1        0.00       99.98
{txt}      249.5 {c |}{res}          1        0.00       99.98
{txt}        250 {c |}{res}          1        0.00       99.98
{txt}      250.5 {c |}{res}          1        0.00       99.98
{txt}        251 {c |}{res}          1        0.00       99.99
{txt}      251.5 {c |}{res}          1        0.00       99.99
{txt}        252 {c |}{res}          1        0.00       99.99
{txt}      252.5 {c |}{res}          1        0.00       99.99
{txt}        253 {c |}{res}          1        0.00       99.99
{txt}      253.5 {c |}{res}          1        0.00       99.99
{txt}        254 {c |}{res}          1        0.00       99.99
{txt}      254.5 {c |}{res}          1        0.00       99.99
{txt}        255 {c |}{res}          1        0.00       99.99
{txt}      255.5 {c |}{res}          1        0.00       99.99
{txt}        256 {c |}{res}          1        0.00       99.99
{txt}      256.5 {c |}{res}          1        0.00       99.99
{txt}        257 {c |}{res}          1        0.00       99.99
{txt}      257.5 {c |}{res}          1        0.00       99.99
{txt}        258 {c |}{res}          1        0.00       99.99
{txt}      258.5 {c |}{res}          1        0.00       99.99
{txt}        259 {c |}{res}          1        0.00       99.99
{txt}      259.5 {c |}{res}          1        0.00       99.99
{txt}        260 {c |}{res}          1        0.00       99.99
{txt}      260.5 {c |}{res}          1        0.00       99.99
{txt}        261 {c |}{res}          1        0.00       99.99
{txt}      261.5 {c |}{res}          1        0.00       99.99
{txt}        262 {c |}{res}          1        0.00       99.99
{txt}      262.5 {c |}{res}          1        0.00       99.99
{txt}        263 {c |}{res}          1        0.00       99.99
{txt}      263.5 {c |}{res}          1        0.00       99.99
{txt}        264 {c |}{res}          1        0.00       99.99
{txt}      264.5 {c |}{res}          1        0.00       99.99
{txt}        265 {c |}{res}          1        0.00       99.99
{txt}      265.5 {c |}{res}          1        0.00       99.99
{txt}        266 {c |}{res}          1        0.00       99.99
{txt}      266.5 {c |}{res}          1        0.00       99.99
{txt}        267 {c |}{res}          1        0.00       99.99
{txt}      267.5 {c |}{res}          1        0.00       99.99
{txt}        268 {c |}{res}          1        0.00       99.99
{txt}      268.5 {c |}{res}          1        0.00       99.99
{txt}        269 {c |}{res}          1        0.00       99.99
{txt}      269.5 {c |}{res}          1        0.00       99.99
{txt}        270 {c |}{res}          1        0.00       99.99
{txt}      270.5 {c |}{res}          1        0.00       99.99
{txt}        271 {c |}{res}         36        0.01      100.00
{txt}{hline 12}{c +}{hline 35}
      Total {c |}{res}    500,583      100.00
{txt}
{com}. 
. drop ts eei_binf
{txt}
{com}. 
.                 **  gen e_bin: upper limit e_max = EEI/100 (kappa + sigma*a)
.                 * Result: Trapezoid (e_max-e_max_n-1)* 0.5 / 2
. 
. gen e_max_digit = 0     // complete cell structure by defining energy values within a cell      
{txt}
{com}. bysort eei_bin a_bin: replace e_max_digit = ((eei_bin+0.5)/100)*(47*a_bin+51.7) // upper limit is (EEI/100)(kappa + sigma*a)
{txt}(1,190,066 real changes made, 689,965 to missing)

{com}. tab e_max_digit if a_bin == 6 & eei_bin == 58.5 // check one cell to confirm: 196.xx  

{txt}e_max_digit {c |}      Freq.     Percent        Cum.
{hline 12}{c +}{hline 35}
    196.883 {c |}{res}     13,771      100.00      100.00
{txt}{hline 12}{c +}{hline 35}
      Total {c |}{res}     13,771      100.00
{txt}
{com}. 
. gen e_min_digit = 0             
{txt}
{com}. bysort eei_bin a_bin: replace e_min_digit = ((eei_bin)/100)*(47*a_bin+51.7) // lower limit 
{txt}(1,190,066 real changes made, 689,965 to missing)

{com}. tab e_min_digit if a_bin == 6 & eei_bin == 58.5 // should be 195.xx 

{txt}e_min_digit {c |}      Freq.     Percent        Cum.
{hline 12}{c +}{hline 35}
   195.2145 {c |}{res}     13,771      100.00      100.00
{txt}{hline 12}{c +}{hline 35}
      Total {c |}{res}     13,771      100.00
{txt}
{com}. 
. gen e_bin = 0           
{txt}
{com}. replace e_bin = floor(e_max_digit)      // rounding down to nearest integer --> value in kwh that a product of given capacity can have to get assigned to this eei bin   
{txt}(1,190,066 real changes made, 689,965 to missing)

{com}. label variable e_max_digit "e(max exact)" 
{txt}
{com}. label variable e_bin "e(max integer)" 
{txt}
{com}.          
.         *** Fillin combinations of both attributes on the grid ****
.  
. sort a_bin eei_bin
{txt}
{com}. fillin a_bin eei_bin    // create all combinations
{txt}
{com}. label variable _fillin "grid fillin"  
{txt}
{com}.          
.         ** Fix: fillin sets year to missing, then those observations would get dropped in collapse  
. replace year = 2017 if year == . & _fillin == 1 // replace those created by _fillin 
{txt}(12,510 real changes made)

{com}. codebook id if year == .                        // all have missing id --> no existing products affected. 

{txt}{hline}
{res}id{right:(unlabeled)}
{txt}{hline}

{col 19}Type: String ({res}str11{txt}), but longest is str0

{col 10}Unique values: {res}0{col 51}{txt}Missing "": {res}493{txt}/{res}493

{txt}{col 13}Tabulation: Freq.  Value
{col 20}{res}       493{col 32}""
{txt}
{com}. replace year = 2017 if year == .        // fix rest on yearly basis. 
{txt}(493 real changes made)

{com}. replace date = 683 if date == .         // fix rest on monthly basis. 
{txt}(13,003 real changes made)

{com}.  
.  
. **** BREAK 1 ******
. save bunching_1_bins_1512, replace 
{txt}{p 0 4 2}
(file {bf}
bunching_1_bins_1512.dta{rm}
not found)
{p_end}
{p 0 4 2}
file {bf}
bunching_1_bins_1512.dta{rm}
saved
{p_end}

{com}. cd // locate file. 
{res}R:\WSV2\TBu_AKe\Bunching_NEW\Data
{txt}
{com}. *******************
. 
.         ** Step 2a: fix missing values **
. drop if a_bin == .                                      
{txt}(5,411 observations deleted)

{com}. drop if eei_bin == .    
{txt}(684,590 observations deleted)

{com}. 
. replace added_a = 1 if added_a == . // 1 if added cell, 0 otherwise.
{txt}(12,474 real changes made)

{com}. replace added_e = 1 if added_e == . // 1 if added cell, 0 otherwise.
{txt}(12,474 real changes made)

{com}. tab added_*                                      

           {txt}{c |}       added_eei
   added_a {c |}         0          1 {c |}     Total
{hline 11}{c +}{hline 22}{c +}{hline 10}
         0 {c |}{res}   500,101          0 {txt}{c |}{res}   500,101 
{txt}         1 {c |}{res}         0     12,474 {txt}{c |}{res}    12,474 
{txt}{hline 11}{c +}{hline 22}{c +}{hline 10}
     Total {c |}{res}   500,101     12,474 {txt}{c |}{res}   512,575 
{txt}
{com}.         
. egen cell=group(eei_bin a_bin)          // Grid of trapezoids with parallel vertical sides, defined by capacity a and index eei  
{txt}
{com}. codebook cell 

{txt}{hline}
{res}cell{right:group(eei_bin a_bin)}
{txt}{hline}

{col 19}Type: Numeric ({res}float{txt})

{col 18}Range: [{res}1{txt},{res}12900{txt}]{col 55}Units: {res}1
{col 10}{txt}Unique values: {res}12,900{col 51}{txt}Missing .: {res}0{txt}/{res}512,575

{txt}{col 19}Mean: {res}{ralign 7:1955.32}
{txt}{col 14}Std. dev.: {res}{ralign 7:1068.32}

{txt}{col 12}Percentiles: {col 25}{ralign 7:10%}{ralign 10:25%}{ralign 10:50%}{ralign 10:75%}{ralign 10:90%}
{res}{col 25}{ralign 7:1267}{ralign 10:    1557}{ralign 10:    1857}{ralign 10:    2230}{ralign 10:    2459}
{txt}
{com}.         * result: 6500 (25*260)
.         
.         ** Define segments in the product space **
. gen r = 0 // restricted
{txt}
{com}. gen b = 0 // bunching 
{txt}
{com}. gen u = 0 // unrestricted 
{txt}
{com}. 
. replace r = 1 if eei_bin >= 59                             // exactly 59 falls under restricted
{txt}(79,728 real changes made)

{com}. replace b = 1 if eei_bin < 59 & eei_bin >= 57 // 2-unit window   
{txt}(69,246 real changes made)

{com}. replace u = 1 if eei_bin < 57                             // lower than eei = 57 
{txt}(363,601 real changes made)

{com}. 
.         ** Step 2b: outcome by cell: country-specific **        
.         
.         ** yearly **
.         
.         ** cell-level sales, country specific
. by eei_bin ccode, sort: egen cell_sales=sum(units) // all years 
{txt}
{com}. by eei_bin year ccode, sort: egen cell_year_sales=sum(units) // by year 
{txt}
{com}. 
.         ** cell-level product count 
. by eei_bin year ccode id,       sort: gen n=_n  
{txt}
{com}. replace n=0                     if n>1 &n!=.  
{txt}(455,830 real changes made)

{com}. replace n=0 if added_a == 1
{txt}(516 real changes made)

{com}. replace n=0 if added_e == 1 
{txt}(0 real changes made)

{com}. by eei_bin year ccode,          sort: egen cell_year_count=sum(n) // by year 
{txt}
{com}. drop n  
{txt}
{com}.         
. by eei_bin ccode id,    sort: gen n=_n  
{txt}
{com}. replace n=0                     if n>1 &n!=. 
{txt}(497,658 real changes made)

{com}. replace n=0 if added_a == 1
{txt}(516 real changes made)

{com}. replace n=0 if added_e == 1 
{txt}(0 real changes made)

{com}. by eei_bin ccode,               sort: egen cell_count=sum(n) // all years 
{txt}
{com}. drop n 
{txt}
{com}. 
.         ** cell-level sales in R and B  
. by eei_bin year ccode, sort: egen cell_year_sales_R=sum(units) if r== 1 // by year 
{txt}(432,847 missing values generated)

{com}. by eei_bin year ccode, sort: egen cell_year_sales_B=sum(units) if b == 1 // by year 
{txt}(443,329 missing values generated)

{com}. 
.         ** cell-level product count in R and B
. by eei_bin year ccode id,       sort: gen n=_n  
{txt}
{com}. replace n=0                     if n>1 &n!=.  
{txt}(455,830 real changes made)

{com}. replace n=0 if added_a == 1
{txt}(516 real changes made)

{com}. replace n=0 if added_e == 1 
{txt}(0 real changes made)

{com}. replace n=0 if r == 0 
{txt}(48,850 real changes made)

{com}. by eei_bin year ccode,          sort: egen cell_year_count_R =sum(n) // by year 
{txt}
{com}. drop n  
{txt}
{com}.         
. by eei_bin year ccode id,       sort: gen n=_n  
{txt}
{com}. replace n=0                     if n>1 &n!=.  
{txt}(455,830 real changes made)

{com}. replace n=0 if added_a == 1
{txt}(516 real changes made)

{com}. replace n=0 if added_e == 1 
{txt}(0 real changes made)

{com}. replace n=0 if b == 0 
{txt}(48,660 real changes made)

{com}. by eei_bin year ccode,          sort: egen cell_year_count_B =sum(n) // by year 
{txt}
{com}. drop n  
{txt}
{com}. 
. sum cell_* // display summary stats  

{txt}    Variable {c |}        Obs        Mean    Std. dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 2}cell_sales {c |}{res}    512,575    247641.1    460318.5          0    2167170
{txt}cell_year_~s {c |}{res}    512,575    43347.81    89082.42          0   515512.2
{txt}cell_year_~t {c |}{res}    512,575    55.49263    64.46295          0        363
{txt}{space 2}cell_count {c |}{res}    512,575    90.99922    95.78416          0        427
{txt}cell_yea~s_R {c |}{res}     79,728    4638.491    9622.407          0   72482.27
{txt}{hline 13}{c +}{hline 57}
cell_yea~s_B {c |}{res}     69,246    36860.93    47893.24          0   205097.4
{txt}cell_yea~t_R {c |}{res}    512,575    1.411013    4.807323          0         34
{txt}cell_yea~t_B {c |}{res}    512,575    7.550316    23.04907          0        146
{txt}
{com}. 
. sum cell if a_bin == 6 & eei_bin == 58 // identify single cell in B to verify correct grid.  

{txt}    Variable {c |}        Obs        Mean    Std. dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 8}cell {c |}{res}      9,587        2232           0       2232       2232
{txt}
{com}. sum cell_* if cell == 2232 & year == 2011 & ccode == 3          // 18. 

{txt}    Variable {c |}        Obs        Mean    Std. dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 2}cell_sales {c |}{res}        201    587956.3           0   587956.3   587956.3
{txt}cell_year_~s {c |}{res}        201    57953.64           0   57953.64   57953.64
{txt}cell_year_~t {c |}{res}        201          25           0         25         25
{txt}{space 2}cell_count {c |}{res}        201          76           0         76         76
{txt}cell_yea~s_R {c |}{res}          0
{txt}{hline 13}{c +}{hline 57}
cell_yea~s_B {c |}{res}        201    57953.64           0   57953.64   57953.64
{txt}cell_yea~t_R {c |}{res}        201           0           0          0          0
{txt}cell_yea~t_B {c |}{res}        201          25           0         25         25
{txt}
{com}. codebook id if cell == 2232 & year == 2011 & ccode == 3         // 18? check. 

{txt}{hline}
{res}id{right:(unlabeled)}
{txt}{hline}

{col 19}Type: String ({res}str11{txt}), but longest is str8

{col 10}Unique values: {res}18{col 51}{txt}Missing "": {res}0{txt}/{res}201

{txt}{col 15}Examples: {res}"58891401"
{col 25}"64575846"
{col 25}"64858535"
{col 25}"65726577"
{txt}
{com}. 
.         ** monthly **
. 
.         ** cell-level sales, country specific
. by eei_bin date ccode, sort: egen cell_date_sales=sum(units) // by date 
{txt}
{com}. 
.         ** cell-level product count 
. by eei_bin date ccode id,       sort: gen n=_n  
{txt}
{com}. replace n=0                     if n>1 &n!=.  
{txt}(11,958 real changes made)

{com}. replace n=0 if added_a == 1
{txt}(516 real changes made)

{com}. replace n=0 if added_e == 1 
{txt}(0 real changes made)

{com}. by eei_bin date ccode,          sort: egen cell_date_count=sum(n) // by date 
{txt}
{com}. drop n  
{txt}
{com}. 
.         ** cell-level sales in R and B  
. by eei_bin date ccode, sort: egen cell_date_sales_R=sum(units) if r== 1 // by date 
{txt}(432,847 missing values generated)

{com}. by eei_bin date ccode, sort: egen cell_date_sales_B=sum(units) if b == 1 // by date 
{txt}(443,329 missing values generated)

{com}. 
.         ** cell-level product count 
. by eei_bin date ccode id,       sort: gen n=_n  
{txt}
{com}. replace n=0                     if n>1 &n!=.  
{txt}(11,958 real changes made)

{com}. replace n=0 if added_a == 1
{txt}(516 real changes made)

{com}. replace n=0 if added_e == 1 
{txt}(0 real changes made)

{com}. replace n=0 if r == 0 
{txt}(430,867 real changes made)

{com}. by eei_bin date ccode,          sort: egen cell_date_count_R =sum(n) // by date 
{txt}
{com}. drop n  
{txt}
{com}.         
. by eei_bin date ccode id,       sort: gen n=_n  
{txt}
{com}. replace n=0                     if n>1 &n!=.  
{txt}(11,958 real changes made)

{com}. replace n=0 if added_a == 1
{txt}(516 real changes made)

{com}. replace n=0 if added_e == 1 
{txt}(0 real changes made)

{com}. replace n=0 if b == 0 
{txt}(430,928 real changes made)

{com}. by eei_bin date ccode,          sort: egen cell_date_count_B =sum(n) // by date 
{txt}
{com}. drop n  
{txt}
{com}. 
.         ** verify structure for single cell 
. sum cell_date* if cell == 2232 & year == 2011 & month == 6 & ccode == 3 // 18 obs, 25 products.  

{txt}    Variable {c |}        Obs        Mean    Std. dev.       Min        Max
{hline 13}{c +}{hline 57}
cell_date_~s {c |}{res}         18    4202.688           0   4202.688   4202.688
{txt}cell_date_~t {c |}{res}         18          25           0         25         25
{txt}cell_dat~s_R {c |}{res}          0
{txt}cell_dat~s_B {c |}{res}         18    4202.688           0   4202.688   4202.688
{txt}cell_dat~t_R {c |}{res}         18           0           0          0          0
{txt}{hline 13}{c +}{hline 57}
cell_dat~t_B {c |}{res}         18          25           0         25         25
{txt}
{com}. codebook id if cell == 2232 & year == 2011 & month == 6 & ccode == 3 // 18? check.

{txt}{hline}
{res}id{right:(unlabeled)}
{txt}{hline}

{col 19}Type: String ({res}str11{txt}), but longest is str8

{col 10}Unique values: {res}18{col 51}{txt}Missing "": {res}0{txt}/{res}18

{txt}{col 15}Examples: {res}"56849503"
{col 25}"64575846"
{col 25}"64844314"
{col 25}"64975069"
{txt}
{com}.         ** total in bin 
. sum cell_date* if eei_bin == 58.5 & year == 2011 & month == 6 & ccode == 3 // 18 obs, 25 products.  

{txt}    Variable {c |}        Obs        Mean    Std. dev.       Min        Max
{hline 13}{c +}{hline 57}
cell_date_~s {c |}{res}         79    13367.25           0   13367.25   13367.25
{txt}cell_date_~t {c |}{res}         79          79           0         79         79
{txt}cell_dat~s_R {c |}{res}          0
{txt}cell_dat~s_B {c |}{res}         79    13367.25           0   13367.25   13367.25
{txt}cell_dat~t_R {c |}{res}         79           0           0          0          0
{txt}{hline 13}{c +}{hline 57}
cell_dat~t_B {c |}{res}         79          79           0         79         79
{txt}
{com}. codebook id if eei_bin == 58.5 & year == 2011 & month == 6 & ccode == 3

{txt}{hline}
{res}id{right:(unlabeled)}
{txt}{hline}

{col 19}Type: String ({res}str11{txt}), but longest is str10

{col 10}Unique values: {res}79{col 51}{txt}Missing "": {res}0{txt}/{res}79

{txt}{col 15}Examples: {res}"53162649"
{col 25}"54093272"
{col 25}"64933626"
{col 25}"65739645"
{txt}
{com}. 
.         ** replace missings for added cells **
.                 ** Set outcomes to zero, but price to . , avoids problems in collapse 
.         
. foreach var of varlist price_all {c -(}
{txt}  2{com}. replace `var' = . if added_a == 1 
{txt}  3{com}. replace `var' = . if added_e == 1 
{txt}  4{com}. {c )-}
{txt}(0 real changes made)
(0 real changes made)

{com}. 
. foreach var of varlist units cell_year_sales cell_year_count cell_date_sales cell_date_count {c -(}
{txt}  2{com}. replace `var' = 0 if added_a == 1 
{txt}  3{com}. replace `var' = 0 if added_e == 1 
{txt}  4{com}. {c )-}
{txt}(12,474 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)

{com}. 
.         ** replace missings in time structure 
. replace year = 2017 if added_a == 1 // missing not tolerated by collapse  
{txt}(0 real changes made)

{com}. replace year = 2017 if added_e == 1 
{txt}(0 real changes made)

{com}. replace date = 683 if added_a == 1 
{txt}(0 real changes made)

{com}. replace date = 683 if added_e == 1 
{txt}(0 real changes made)

{com}. 
. gsort date +year +month 
{txt}
{com}. bysort date: carryforward year, replace
year:  {txt}(0 real changes made)
{res}{txt}
{com}. bysort date: carryforward month, replace 
month:  {txt}(12,474 real changes made)
{res}{txt}
{com}. 
. 
. **** BREAK 2 ******
. save bunching_1_bins_1512, replace 
{txt}{p 0 4 2}
file {bf}
bunching_1_bins_1512.dta{rm}
saved
{p_end}

{com}. cd // locate file. 
{res}R:\WSV2\TBu_AKe\Bunching_NEW\Data
{txt}
{com}. *******************
.         
.         *************************************************************
.         ** Step 2c : collapse product-level data to bin-level data ** 
. 
.         ************************
.         ** date-country level **
.         ************************
. 
. preserve 
{txt}
{com}. 
.                 *** monthly *** 
. sort eei_bin ccode year month // sort order  
{txt}
{com}. gen price2 = price_all // duplicated to get total expenditure and mean price 
{txt}(181,925 missing values generated)

{com}. gen kwh_max = kwh // duplicate to keep max value (within-cell bunchpoint)
{txt}(12,474 missing values generated)

{com}. replace ccode = 0 if missing(ccode)
{txt}(12,474 real changes made)

{com}. #delimit ;
{txt}delimiter now ;
{com}. collapse (max) cell_year_sales cell_year_count cell_date_sales cell_date_count kwh_max e_max_digit e_min_digit cell
>                  (sum) units units_clean price_all b r u  
>                  (mean) e_bin a_bin capacity kwh price2 eei age_xc age_country 
>                  (firstnm) added_a added_e year month, 
>                  by(eei_bin ccode date);
{res}{txt}
{com}.  #delimit cr
{txt}delimiter now cr
{com}. order cell_*, last 
{txt}
{com}. order price_all price2, last 
{txt}
{com}. order capacity kwh units added_a added_e, last
{txt}
{com}. 
.         ** 2d: clean up data structure to balanced panel (cell-country-period level)
. 
.         ** Fillin to balance panel (assume: missing = 0, i.e. product-combo not offered/sold at time t)
. fillin eei_bin ccode date                                       // all combinations  
{txt}
{com}. codebook eei_bin                                                        // 260*8*157 (157 is number of monthly periods)

{txt}{hline}
{res}eei_bin{right:EEI in 0.5-unit bins}
{txt}{hline}

{col 19}Type: Numeric ({res}float{txt})

{col 18}Range: [{res}13.5{txt},{res}271{txt}]{col 55}Units: {res}.1
{col 10}{txt}Unique values: {res}516{col 51}{txt}Missing .: {res}0{txt}/{res}648,096

{txt}{col 19}Mean: {res}{ralign 7:142.25}
{txt}{col 14}Std. dev.: {res}{ralign 7:74.4781}

{txt}{col 12}Percentiles: {col 25}{ralign 7:10%}{ralign 10:25%}{ralign 10:50%}{ralign 10:75%}{ralign 10:90%}
{res}{col 25}{ralign 7:39}{ralign 10:   77.75}{ralign 10:  142.25}{ralign 10:  206.75}{ralign 10:   245.5}
{txt}
{com}. xtset eei_bin                                                           // check if balanced 

{txt}{col 1}Panel variable: {res}eei_bin{txt} (balanced)

{com}. 
. tab _fillin                                                     

    {txt}_fillin {c |}      Freq.     Percent        Cum.
{hline 12}{c +}{hline 35}
          0 {c |}{res}     52,631        8.12        8.12
{txt}          1 {c |}{res}    595,465       91.88      100.00
{txt}{hline 12}{c +}{hline 35}
      Total {c |}{res}    648,096      100.00
{txt}
{com}. label variable _fillin "bin-date_fill" 
{txt}
{com}. replace added_a = 1 if added_a == .     //   
{txt}(595,465 real changes made)

{com}. drop added_e                                                    // identical to added_a after collapse (added cells by either attribute identify same sub-set) 
{txt}
{com}. 
.         ** Time variables 
. gsort date +year +month                                 // fillin relies on date, month and year needed for regression
{txt}
{com}. bysort date: carryforward year, replace
year:  {txt}(595,465 real changes made)
{res}{txt}
{com}. bysort date: carryforward month, replace 
month:  {txt}(595,465 real changes made)
{res}{txt}
{com}. 
. 
.         ** Replace missings with zero for outcome, set price missing if zero
. foreach var of varlist cell_date_count cell_date_sales units {c -(}
{txt}  2{com}.         replace `var' = 0 if `var' == . 
{txt}  3{com}.         replace `var' = 0 if added_a == 1 & _fillin == 0 // from collapse structure
{txt}  4{com}. {c )-}
{txt}(595,465 real changes made)
(0 real changes made)
(595,465 real changes made)
(0 real changes made)
(595,465 real changes made)
(0 real changes made)

{com}. 
. foreach var of varlist price_all price2 {c -(}
{txt}  2{com}.         replace `var' = . if `var' == 0  // zero price does not exist in this set, but possible in other cases.  
{txt}  3{com}. {c )-}
{txt}(10,994 real changes made, 10,994 to missing)
(2,155 real changes made, 2,155 to missing)

{com}. 
.         ** Fill in missings in a_bin and e_bin from cell address 
. 
.         ** capacity 
. gsort cell +a_bin
{txt}
{com}. bysort cell: carryforward a_bin, gen(a_bin3)
a_bin3:  {txt}(0 real changes made)
{res}{txt}
{com}. 
. quietly list cell a_bin a_bin3, clean noobs
{txt}
{com}. 
. replace a_bin = a_bin3 
{txt}(0 real changes made)

{com}. drop a_bin3
{txt}
{com}. 
.         ** eei in bins 
. gsort cell +eei_bin
{txt}
{com}. bysort cell: carryforward eei_bin, gen(eei_bin3)
eei_bin3:  {txt}(0 real changes made)
{res}{txt}
{com}. quietly list cell eei_bin eei_bin3, clean noobs
{txt}
{com}. 
. replace eei_bin = eei_bin3 if eei_bin == .  
{txt}(0 real changes made)

{com}. drop eei_bin3
{txt}
{com}. 
.         ** fix e_bin to eliminate missings based on a_bin, eei_bin.     
. bysort eei_bin a_bin: replace e_max_digit = ((eei_bin+0.5)/100)*(47*a_bin+51.7) // within-cell bunchpoint 
{txt}(27,111 real changes made)

{com}. tab e_max_digit if a_bin == 6 & eei_bin == 58.5 // check individual cell                

      {txt}(max) {c |}
e_max_digit {c |}      Freq.     Percent        Cum.
{hline 12}{c +}{hline 35}
    196.883 {c |}{res}         36      100.00      100.00
{txt}{hline 12}{c +}{hline 35}
      Total {c |}{res}         36      100.00
{txt}
{com}. replace e_bin = floor(e_max_digit) // rounding down to nearest integer  
{txt}(21,244 real changes made)

{com}. 
. label variable e_max_digit "e(max exact)" 
{txt}
{com}. label variable e_bin "e(max integer)" 
{txt}
{com}. 
. gsort cell +e_bin
{txt}
{com}. bysort cell: carryforward e_bin, gen(e_bin3)
e_bin3:  {txt}(0 real changes made)
{res}{txt}
{com}. quietly list cell e_bin e_bin3, clean noobs
{txt}
{com}. 
. replace e_bin = e_bin3 
{txt}(0 real changes made)

{com}. drop e_bin3 
{txt}
{com}. 
.         ** check  
. tab eei_bin, missing // no more missings.  

     {txt}EEI in {c |}
   0.5-unit {c |}
       bins {c |}      Freq.     Percent        Cum.
{hline 12}{c +}{hline 35}
       13.5 {c |}{res}      1,256        0.19        0.19
{txt}         14 {c |}{res}      1,256        0.19        0.39
{txt}       14.5 {c |}{res}      1,256        0.19        0.58
{txt}         15 {c |}{res}      1,256        0.19        0.78
{txt}       15.5 {c |}{res}      1,256        0.19        0.97
{txt}         16 {c |}{res}      1,256        0.19        1.16
{txt}       16.5 {c |}{res}      1,256        0.19        1.36
{txt}         17 {c |}{res}      1,256        0.19        1.55
{txt}       17.5 {c |}{res}      1,256        0.19        1.74
{txt}         18 {c |}{res}      1,256        0.19        1.94
{txt}       18.5 {c |}{res}      1,256        0.19        2.13
{txt}         19 {c |}{res}      1,256        0.19        2.33
{txt}       19.5 {c |}{res}      1,256        0.19        2.52
{txt}         20 {c |}{res}      1,256        0.19        2.71
{txt}       20.5 {c |}{res}      1,256        0.19        2.91
{txt}         21 {c |}{res}      1,256        0.19        3.10
{txt}       21.5 {c |}{res}      1,256        0.19        3.29
{txt}         22 {c |}{res}      1,256        0.19        3.49
{txt}       22.5 {c |}{res}      1,256        0.19        3.68
{txt}         23 {c |}{res}      1,256        0.19        3.88
{txt}       23.5 {c |}{res}      1,256        0.19        4.07
{txt}         24 {c |}{res}      1,256        0.19        4.26
{txt}       24.5 {c |}{res}      1,256        0.19        4.46
{txt}         25 {c |}{res}      1,256        0.19        4.65
{txt}       25.5 {c |}{res}      1,256        0.19        4.84
{txt}         26 {c |}{res}      1,256        0.19        5.04
{txt}       26.5 {c |}{res}      1,256        0.19        5.23
{txt}         27 {c |}{res}      1,256        0.19        5.43
{txt}       27.5 {c |}{res}      1,256        0.19        5.62
{txt}         28 {c |}{res}      1,256        0.19        5.81
{txt}       28.5 {c |}{res}      1,256        0.19        6.01
{txt}         29 {c |}{res}      1,256        0.19        6.20
{txt}       29.5 {c |}{res}      1,256        0.19        6.40
{txt}         30 {c |}{res}      1,256        0.19        6.59
{txt}       30.5 {c |}{res}      1,256        0.19        6.78
{txt}         31 {c |}{res}      1,256        0.19        6.98
{txt}       31.5 {c |}{res}      1,256        0.19        7.17
{txt}         32 {c |}{res}      1,256        0.19        7.36
{txt}       32.5 {c |}{res}      1,256        0.19        7.56
{txt}         33 {c |}{res}      1,256        0.19        7.75
{txt}       33.5 {c |}{res}      1,256        0.19        7.95
{txt}         34 {c |}{res}      1,256        0.19        8.14
{txt}       34.5 {c |}{res}      1,256        0.19        8.33
{txt}         35 {c |}{res}      1,256        0.19        8.53
{txt}       35.5 {c |}{res}      1,256        0.19        8.72
{txt}         36 {c |}{res}      1,256        0.19        8.91
{txt}       36.5 {c |}{res}      1,256        0.19        9.11
{txt}         37 {c |}{res}      1,256        0.19        9.30
{txt}       37.5 {c |}{res}      1,256        0.19        9.50
{txt}         38 {c |}{res}      1,256        0.19        9.69
{txt}       38.5 {c |}{res}      1,256        0.19        9.88
{txt}         39 {c |}{res}      1,256        0.19       10.08
{txt}       39.5 {c |}{res}      1,256        0.19       10.27
{txt}         40 {c |}{res}      1,256        0.19       10.47
{txt}       40.5 {c |}{res}      1,256        0.19       10.66
{txt}         41 {c |}{res}      1,256        0.19       10.85
{txt}       41.5 {c |}{res}      1,256        0.19       11.05
{txt}         42 {c |}{res}      1,256        0.19       11.24
{txt}       42.5 {c |}{res}      1,256        0.19       11.43
{txt}         43 {c |}{res}      1,256        0.19       11.63
{txt}       43.5 {c |}{res}      1,256        0.19       11.82
{txt}         44 {c |}{res}      1,256        0.19       12.02
{txt}       44.5 {c |}{res}      1,256        0.19       12.21
{txt}         45 {c |}{res}      1,256        0.19       12.40
{txt}       45.5 {c |}{res}      1,256        0.19       12.60
{txt}         46 {c |}{res}      1,256        0.19       12.79
{txt}       46.5 {c |}{res}      1,256        0.19       12.98
{txt}         47 {c |}{res}      1,256        0.19       13.18
{txt}       47.5 {c |}{res}      1,256        0.19       13.37
{txt}         48 {c |}{res}      1,256        0.19       13.57
{txt}       48.5 {c |}{res}      1,256        0.19       13.76
{txt}         49 {c |}{res}      1,256        0.19       13.95
{txt}       49.5 {c |}{res}      1,256        0.19       14.15
{txt}         50 {c |}{res}      1,256        0.19       14.34
{txt}       50.5 {c |}{res}      1,256        0.19       14.53
{txt}         51 {c |}{res}      1,256        0.19       14.73
{txt}       51.5 {c |}{res}      1,256        0.19       14.92
{txt}         52 {c |}{res}      1,256        0.19       15.12
{txt}       52.5 {c |}{res}      1,256        0.19       15.31
{txt}         53 {c |}{res}      1,256        0.19       15.50
{txt}       53.5 {c |}{res}      1,256        0.19       15.70
{txt}         54 {c |}{res}      1,256        0.19       15.89
{txt}       54.5 {c |}{res}      1,256        0.19       16.09
{txt}         55 {c |}{res}      1,256        0.19       16.28
{txt}       55.5 {c |}{res}      1,256        0.19       16.47
{txt}         56 {c |}{res}      1,256        0.19       16.67
{txt}       56.5 {c |}{res}      1,256        0.19       16.86
{txt}         57 {c |}{res}      1,256        0.19       17.05
{txt}       57.5 {c |}{res}      1,256        0.19       17.25
{txt}         58 {c |}{res}      1,256        0.19       17.44
{txt}       58.5 {c |}{res}      1,256        0.19       17.64
{txt}         59 {c |}{res}      1,256        0.19       17.83
{txt}       59.5 {c |}{res}      1,256        0.19       18.02
{txt}         60 {c |}{res}      1,256        0.19       18.22
{txt}       60.5 {c |}{res}      1,256        0.19       18.41
{txt}         61 {c |}{res}      1,256        0.19       18.60
{txt}       61.5 {c |}{res}      1,256        0.19       18.80
{txt}         62 {c |}{res}      1,256        0.19       18.99
{txt}       62.5 {c |}{res}      1,256        0.19       19.19
{txt}         63 {c |}{res}      1,256        0.19       19.38
{txt}       63.5 {c |}{res}      1,256        0.19       19.57
{txt}         64 {c |}{res}      1,256        0.19       19.77
{txt}       64.5 {c |}{res}      1,256        0.19       19.96
{txt}         65 {c |}{res}      1,256        0.19       20.16
{txt}       65.5 {c |}{res}      1,256        0.19       20.35
{txt}         66 {c |}{res}      1,256        0.19       20.54
{txt}       66.5 {c |}{res}      1,256        0.19       20.74
{txt}         67 {c |}{res}      1,256        0.19       20.93
{txt}       67.5 {c |}{res}      1,256        0.19       21.12
{txt}         68 {c |}{res}      1,256        0.19       21.32
{txt}       68.5 {c |}{res}      1,256        0.19       21.51
{txt}         69 {c |}{res}      1,256        0.19       21.71
{txt}       69.5 {c |}{res}      1,256        0.19       21.90
{txt}         70 {c |}{res}      1,256        0.19       22.09
{txt}       70.5 {c |}{res}      1,256        0.19       22.29
{txt}         71 {c |}{res}      1,256        0.19       22.48
{txt}       71.5 {c |}{res}      1,256        0.19       22.67
{txt}         72 {c |}{res}      1,256        0.19       22.87
{txt}       72.5 {c |}{res}      1,256        0.19       23.06
{txt}         73 {c |}{res}      1,256        0.19       23.26
{txt}       73.5 {c |}{res}      1,256        0.19       23.45
{txt}         74 {c |}{res}      1,256        0.19       23.64
{txt}       74.5 {c |}{res}      1,256        0.19       23.84
{txt}         75 {c |}{res}      1,256        0.19       24.03
{txt}       75.5 {c |}{res}      1,256        0.19       24.22
{txt}         76 {c |}{res}      1,256        0.19       24.42
{txt}       76.5 {c |}{res}      1,256        0.19       24.61
{txt}         77 {c |}{res}      1,256        0.19       24.81
{txt}       77.5 {c |}{res}      1,256        0.19       25.00
{txt}         78 {c |}{res}      1,256        0.19       25.19
{txt}       78.5 {c |}{res}      1,256        0.19       25.39
{txt}         79 {c |}{res}      1,256        0.19       25.58
{txt}       79.5 {c |}{res}      1,256        0.19       25.78
{txt}         80 {c |}{res}      1,256        0.19       25.97
{txt}       80.5 {c |}{res}      1,256        0.19       26.16
{txt}         81 {c |}{res}      1,256        0.19       26.36
{txt}       81.5 {c |}{res}      1,256        0.19       26.55
{txt}         82 {c |}{res}      1,256        0.19       26.74
{txt}       82.5 {c |}{res}      1,256        0.19       26.94
{txt}         83 {c |}{res}      1,256        0.19       27.13
{txt}       83.5 {c |}{res}      1,256        0.19       27.33
{txt}         84 {c |}{res}      1,256        0.19       27.52
{txt}       84.5 {c |}{res}      1,256        0.19       27.71
{txt}         85 {c |}{res}      1,256        0.19       27.91
{txt}       85.5 {c |}{res}      1,256        0.19       28.10
{txt}         86 {c |}{res}      1,256        0.19       28.29
{txt}       86.5 {c |}{res}      1,256        0.19       28.49
{txt}         87 {c |}{res}      1,256        0.19       28.68
{txt}       87.5 {c |}{res}      1,256        0.19       28.88
{txt}         88 {c |}{res}      1,256        0.19       29.07
{txt}       88.5 {c |}{res}      1,256        0.19       29.26
{txt}         89 {c |}{res}      1,256        0.19       29.46
{txt}       89.5 {c |}{res}      1,256        0.19       29.65
{txt}         90 {c |}{res}      1,256        0.19       29.84
{txt}       90.5 {c |}{res}      1,256        0.19       30.04
{txt}         91 {c |}{res}      1,256        0.19       30.23
{txt}       91.5 {c |}{res}      1,256        0.19       30.43
{txt}         92 {c |}{res}      1,256        0.19       30.62
{txt}       92.5 {c |}{res}      1,256        0.19       30.81
{txt}         93 {c |}{res}      1,256        0.19       31.01
{txt}       93.5 {c |}{res}      1,256        0.19       31.20
{txt}         94 {c |}{res}      1,256        0.19       31.40
{txt}       94.5 {c |}{res}      1,256        0.19       31.59
{txt}         95 {c |}{res}      1,256        0.19       31.78
{txt}       95.5 {c |}{res}      1,256        0.19       31.98
{txt}         96 {c |}{res}      1,256        0.19       32.17
{txt}       96.5 {c |}{res}      1,256        0.19       32.36
{txt}         97 {c |}{res}      1,256        0.19       32.56
{txt}       97.5 {c |}{res}      1,256        0.19       32.75
{txt}         98 {c |}{res}      1,256        0.19       32.95
{txt}       98.5 {c |}{res}      1,256        0.19       33.14
{txt}         99 {c |}{res}      1,256        0.19       33.33
{txt}       99.5 {c |}{res}      1,256        0.19       33.53
{txt}        100 {c |}{res}      1,256        0.19       33.72
{txt}      100.5 {c |}{res}      1,256        0.19       33.91
{txt}        101 {c |}{res}      1,256        0.19       34.11
{txt}      101.5 {c |}{res}      1,256        0.19       34.30
{txt}        102 {c |}{res}      1,256        0.19       34.50
{txt}      102.5 {c |}{res}      1,256        0.19       34.69
{txt}        103 {c |}{res}      1,256        0.19       34.88
{txt}      103.5 {c |}{res}      1,256        0.19       35.08
{txt}        104 {c |}{res}      1,256        0.19       35.27
{txt}      104.5 {c |}{res}      1,256        0.19       35.47
{txt}        105 {c |}{res}      1,256        0.19       35.66
{txt}      105.5 {c |}{res}      1,256        0.19       35.85
{txt}        106 {c |}{res}      1,256        0.19       36.05
{txt}      106.5 {c |}{res}      1,256        0.19       36.24
{txt}        107 {c |}{res}      1,256        0.19       36.43
{txt}      107.5 {c |}{res}      1,256        0.19       36.63
{txt}        108 {c |}{res}      1,256        0.19       36.82
{txt}      108.5 {c |}{res}      1,256        0.19       37.02
{txt}        109 {c |}{res}      1,256        0.19       37.21
{txt}      109.5 {c |}{res}      1,256        0.19       37.40
{txt}        110 {c |}{res}      1,256        0.19       37.60
{txt}      110.5 {c |}{res}      1,256        0.19       37.79
{txt}        111 {c |}{res}      1,256        0.19       37.98
{txt}      111.5 {c |}{res}      1,256        0.19       38.18
{txt}        112 {c |}{res}      1,256        0.19       38.37
{txt}      112.5 {c |}{res}      1,256        0.19       38.57
{txt}        113 {c |}{res}      1,256        0.19       38.76
{txt}      113.5 {c |}{res}      1,256        0.19       38.95
{txt}        114 {c |}{res}      1,256        0.19       39.15
{txt}      114.5 {c |}{res}      1,256        0.19       39.34
{txt}        115 {c |}{res}      1,256        0.19       39.53
{txt}      115.5 {c |}{res}      1,256        0.19       39.73
{txt}        116 {c |}{res}      1,256        0.19       39.92
{txt}      116.5 {c |}{res}      1,256        0.19       40.12
{txt}        117 {c |}{res}      1,256        0.19       40.31
{txt}      117.5 {c |}{res}      1,256        0.19       40.50
{txt}        118 {c |}{res}      1,256        0.19       40.70
{txt}      118.5 {c |}{res}      1,256        0.19       40.89
{txt}        119 {c |}{res}      1,256        0.19       41.09
{txt}      119.5 {c |}{res}      1,256        0.19       41.28
{txt}        120 {c |}{res}      1,256        0.19       41.47
{txt}      120.5 {c |}{res}      1,256        0.19       41.67
{txt}        121 {c |}{res}      1,256        0.19       41.86
{txt}      121.5 {c |}{res}      1,256        0.19       42.05
{txt}        122 {c |}{res}      1,256        0.19       42.25
{txt}      122.5 {c |}{res}      1,256        0.19       42.44
{txt}        123 {c |}{res}      1,256        0.19       42.64
{txt}      123.5 {c |}{res}      1,256        0.19       42.83
{txt}        124 {c |}{res}      1,256        0.19       43.02
{txt}      124.5 {c |}{res}      1,256        0.19       43.22
{txt}        125 {c |}{res}      1,256        0.19       43.41
{txt}      125.5 {c |}{res}      1,256        0.19       43.60
{txt}        126 {c |}{res}      1,256        0.19       43.80
{txt}      126.5 {c |}{res}      1,256        0.19       43.99
{txt}        127 {c |}{res}      1,256        0.19       44.19
{txt}      127.5 {c |}{res}      1,256        0.19       44.38
{txt}        128 {c |}{res}      1,256        0.19       44.57
{txt}      128.5 {c |}{res}      1,256        0.19       44.77
{txt}        129 {c |}{res}      1,256        0.19       44.96
{txt}      129.5 {c |}{res}      1,256        0.19       45.16
{txt}        130 {c |}{res}      1,256        0.19       45.35
{txt}      130.5 {c |}{res}      1,256        0.19       45.54
{txt}        131 {c |}{res}      1,256        0.19       45.74
{txt}      131.5 {c |}{res}      1,256        0.19       45.93
{txt}        132 {c |}{res}      1,256        0.19       46.12
{txt}      132.5 {c |}{res}      1,256        0.19       46.32
{txt}        133 {c |}{res}      1,256        0.19       46.51
{txt}      133.5 {c |}{res}      1,256        0.19       46.71
{txt}        134 {c |}{res}      1,256        0.19       46.90
{txt}      134.5 {c |}{res}      1,256        0.19       47.09
{txt}        135 {c |}{res}      1,256        0.19       47.29
{txt}      135.5 {c |}{res}      1,256        0.19       47.48
{txt}        136 {c |}{res}      1,256        0.19       47.67
{txt}      136.5 {c |}{res}      1,256        0.19       47.87
{txt}        137 {c |}{res}      1,256        0.19       48.06
{txt}      137.5 {c |}{res}      1,256        0.19       48.26
{txt}        138 {c |}{res}      1,256        0.19       48.45
{txt}      138.5 {c |}{res}      1,256        0.19       48.64
{txt}        139 {c |}{res}      1,256        0.19       48.84
{txt}      139.5 {c |}{res}      1,256        0.19       49.03
{txt}        140 {c |}{res}      1,256        0.19       49.22
{txt}      140.5 {c |}{res}      1,256        0.19       49.42
{txt}        141 {c |}{res}      1,256        0.19       49.61
{txt}      141.5 {c |}{res}      1,256        0.19       49.81
{txt}        142 {c |}{res}      1,256        0.19       50.00
{txt}      142.5 {c |}{res}      1,256        0.19       50.19
{txt}        143 {c |}{res}      1,256        0.19       50.39
{txt}      143.5 {c |}{res}      1,256        0.19       50.58
{txt}        144 {c |}{res}      1,256        0.19       50.78
{txt}      144.5 {c |}{res}      1,256        0.19       50.97
{txt}        145 {c |}{res}      1,256        0.19       51.16
{txt}      145.5 {c |}{res}      1,256        0.19       51.36
{txt}        146 {c |}{res}      1,256        0.19       51.55
{txt}      146.5 {c |}{res}      1,256        0.19       51.74
{txt}        147 {c |}{res}      1,256        0.19       51.94
{txt}      147.5 {c |}{res}      1,256        0.19       52.13
{txt}        148 {c |}{res}      1,256        0.19       52.33
{txt}      148.5 {c |}{res}      1,256        0.19       52.52
{txt}        149 {c |}{res}      1,256        0.19       52.71
{txt}      149.5 {c |}{res}      1,256        0.19       52.91
{txt}        150 {c |}{res}      1,256        0.19       53.10
{txt}      150.5 {c |}{res}      1,256        0.19       53.29
{txt}        151 {c |}{res}      1,256        0.19       53.49
{txt}      151.5 {c |}{res}      1,256        0.19       53.68
{txt}        152 {c |}{res}      1,256        0.19       53.88
{txt}      152.5 {c |}{res}      1,256        0.19       54.07
{txt}        153 {c |}{res}      1,256        0.19       54.26
{txt}      153.5 {c |}{res}      1,256        0.19       54.46
{txt}        154 {c |}{res}      1,256        0.19       54.65
{txt}      154.5 {c |}{res}      1,256        0.19       54.84
{txt}        155 {c |}{res}      1,256        0.19       55.04
{txt}      155.5 {c |}{res}      1,256        0.19       55.23
{txt}        156 {c |}{res}      1,256        0.19       55.43
{txt}      156.5 {c |}{res}      1,256        0.19       55.62
{txt}        157 {c |}{res}      1,256        0.19       55.81
{txt}      157.5 {c |}{res}      1,256        0.19       56.01
{txt}        158 {c |}{res}      1,256        0.19       56.20
{txt}      158.5 {c |}{res}      1,256        0.19       56.40
{txt}        159 {c |}{res}      1,256        0.19       56.59
{txt}      159.5 {c |}{res}      1,256        0.19       56.78
{txt}        160 {c |}{res}      1,256        0.19       56.98
{txt}      160.5 {c |}{res}      1,256        0.19       57.17
{txt}        161 {c |}{res}      1,256        0.19       57.36
{txt}      161.5 {c |}{res}      1,256        0.19       57.56
{txt}        162 {c |}{res}      1,256        0.19       57.75
{txt}      162.5 {c |}{res}      1,256        0.19       57.95
{txt}        163 {c |}{res}      1,256        0.19       58.14
{txt}      163.5 {c |}{res}      1,256        0.19       58.33
{txt}        164 {c |}{res}      1,256        0.19       58.53
{txt}      164.5 {c |}{res}      1,256        0.19       58.72
{txt}        165 {c |}{res}      1,256        0.19       58.91
{txt}      165.5 {c |}{res}      1,256        0.19       59.11
{txt}        166 {c |}{res}      1,256        0.19       59.30
{txt}      166.5 {c |}{res}      1,256        0.19       59.50
{txt}        167 {c |}{res}      1,256        0.19       59.69
{txt}      167.5 {c |}{res}      1,256        0.19       59.88
{txt}        168 {c |}{res}      1,256        0.19       60.08
{txt}      168.5 {c |}{res}      1,256        0.19       60.27
{txt}        169 {c |}{res}      1,256        0.19       60.47
{txt}      169.5 {c |}{res}      1,256        0.19       60.66
{txt}        170 {c |}{res}      1,256        0.19       60.85
{txt}      170.5 {c |}{res}      1,256        0.19       61.05
{txt}        171 {c |}{res}      1,256        0.19       61.24
{txt}      171.5 {c |}{res}      1,256        0.19       61.43
{txt}        172 {c |}{res}      1,256        0.19       61.63
{txt}      172.5 {c |}{res}      1,256        0.19       61.82
{txt}        173 {c |}{res}      1,256        0.19       62.02
{txt}      173.5 {c |}{res}      1,256        0.19       62.21
{txt}        174 {c |}{res}      1,256        0.19       62.40
{txt}      174.5 {c |}{res}      1,256        0.19       62.60
{txt}        175 {c |}{res}      1,256        0.19       62.79
{txt}      175.5 {c |}{res}      1,256        0.19       62.98
{txt}        176 {c |}{res}      1,256        0.19       63.18
{txt}      176.5 {c |}{res}      1,256        0.19       63.37
{txt}        177 {c |}{res}      1,256        0.19       63.57
{txt}      177.5 {c |}{res}      1,256        0.19       63.76
{txt}        178 {c |}{res}      1,256        0.19       63.95
{txt}      178.5 {c |}{res}      1,256        0.19       64.15
{txt}        179 {c |}{res}      1,256        0.19       64.34
{txt}      179.5 {c |}{res}      1,256        0.19       64.53
{txt}        180 {c |}{res}      1,256        0.19       64.73
{txt}      180.5 {c |}{res}      1,256        0.19       64.92
{txt}        181 {c |}{res}      1,256        0.19       65.12
{txt}      181.5 {c |}{res}      1,256        0.19       65.31
{txt}        182 {c |}{res}      1,256        0.19       65.50
{txt}      182.5 {c |}{res}      1,256        0.19       65.70
{txt}        183 {c |}{res}      1,256        0.19       65.89
{txt}      183.5 {c |}{res}      1,256        0.19       66.09
{txt}        184 {c |}{res}      1,256        0.19       66.28
{txt}      184.5 {c |}{res}      1,256        0.19       66.47
{txt}        185 {c |}{res}      1,256        0.19       66.67
{txt}      185.5 {c |}{res}      1,256        0.19       66.86
{txt}        186 {c |}{res}      1,256        0.19       67.05
{txt}      186.5 {c |}{res}      1,256        0.19       67.25
{txt}        187 {c |}{res}      1,256        0.19       67.44
{txt}      187.5 {c |}{res}      1,256        0.19       67.64
{txt}        188 {c |}{res}      1,256        0.19       67.83
{txt}      188.5 {c |}{res}      1,256        0.19       68.02
{txt}        189 {c |}{res}      1,256        0.19       68.22
{txt}      189.5 {c |}{res}      1,256        0.19       68.41
{txt}        190 {c |}{res}      1,256        0.19       68.60
{txt}      190.5 {c |}{res}      1,256        0.19       68.80
{txt}        191 {c |}{res}      1,256        0.19       68.99
{txt}      191.5 {c |}{res}      1,256        0.19       69.19
{txt}        192 {c |}{res}      1,256        0.19       69.38
{txt}      192.5 {c |}{res}      1,256        0.19       69.57
{txt}        193 {c |}{res}      1,256        0.19       69.77
{txt}      193.5 {c |}{res}      1,256        0.19       69.96
{txt}        194 {c |}{res}      1,256        0.19       70.16
{txt}      194.5 {c |}{res}      1,256        0.19       70.35
{txt}        195 {c |}{res}      1,256        0.19       70.54
{txt}      195.5 {c |}{res}      1,256        0.19       70.74
{txt}        196 {c |}{res}      1,256        0.19       70.93
{txt}      196.5 {c |}{res}      1,256        0.19       71.12
{txt}        197 {c |}{res}      1,256        0.19       71.32
{txt}      197.5 {c |}{res}      1,256        0.19       71.51
{txt}        198 {c |}{res}      1,256        0.19       71.71
{txt}      198.5 {c |}{res}      1,256        0.19       71.90
{txt}        199 {c |}{res}      1,256        0.19       72.09
{txt}      199.5 {c |}{res}      1,256        0.19       72.29
{txt}        200 {c |}{res}      1,256        0.19       72.48
{txt}      200.5 {c |}{res}      1,256        0.19       72.67
{txt}        201 {c |}{res}      1,256        0.19       72.87
{txt}      201.5 {c |}{res}      1,256        0.19       73.06
{txt}        202 {c |}{res}      1,256        0.19       73.26
{txt}      202.5 {c |}{res}      1,256        0.19       73.45
{txt}        203 {c |}{res}      1,256        0.19       73.64
{txt}      203.5 {c |}{res}      1,256        0.19       73.84
{txt}        204 {c |}{res}      1,256        0.19       74.03
{txt}      204.5 {c |}{res}      1,256        0.19       74.22
{txt}        205 {c |}{res}      1,256        0.19       74.42
{txt}      205.5 {c |}{res}      1,256        0.19       74.61
{txt}        206 {c |}{res}      1,256        0.19       74.81
{txt}      206.5 {c |}{res}      1,256        0.19       75.00
{txt}        207 {c |}{res}      1,256        0.19       75.19
{txt}      207.5 {c |}{res}      1,256        0.19       75.39
{txt}        208 {c |}{res}      1,256        0.19       75.58
{txt}      208.5 {c |}{res}      1,256        0.19       75.78
{txt}        209 {c |}{res}      1,256        0.19       75.97
{txt}      209.5 {c |}{res}      1,256        0.19       76.16
{txt}        210 {c |}{res}      1,256        0.19       76.36
{txt}      210.5 {c |}{res}      1,256        0.19       76.55
{txt}        211 {c |}{res}      1,256        0.19       76.74
{txt}      211.5 {c |}{res}      1,256        0.19       76.94
{txt}        212 {c |}{res}      1,256        0.19       77.13
{txt}      212.5 {c |}{res}      1,256        0.19       77.33
{txt}        213 {c |}{res}      1,256        0.19       77.52
{txt}      213.5 {c |}{res}      1,256        0.19       77.71
{txt}        214 {c |}{res}      1,256        0.19       77.91
{txt}      214.5 {c |}{res}      1,256        0.19       78.10
{txt}        215 {c |}{res}      1,256        0.19       78.29
{txt}      215.5 {c |}{res}      1,256        0.19       78.49
{txt}        216 {c |}{res}      1,256        0.19       78.68
{txt}      216.5 {c |}{res}      1,256        0.19       78.88
{txt}        217 {c |}{res}      1,256        0.19       79.07
{txt}      217.5 {c |}{res}      1,256        0.19       79.26
{txt}        218 {c |}{res}      1,256        0.19       79.46
{txt}      218.5 {c |}{res}      1,256        0.19       79.65
{txt}        219 {c |}{res}      1,256        0.19       79.84
{txt}      219.5 {c |}{res}      1,256        0.19       80.04
{txt}        220 {c |}{res}      1,256        0.19       80.23
{txt}      220.5 {c |}{res}      1,256        0.19       80.43
{txt}        221 {c |}{res}      1,256        0.19       80.62
{txt}      221.5 {c |}{res}      1,256        0.19       80.81
{txt}        222 {c |}{res}      1,256        0.19       81.01
{txt}      222.5 {c |}{res}      1,256        0.19       81.20
{txt}        223 {c |}{res}      1,256        0.19       81.40
{txt}      223.5 {c |}{res}      1,256        0.19       81.59
{txt}        224 {c |}{res}      1,256        0.19       81.78
{txt}      224.5 {c |}{res}      1,256        0.19       81.98
{txt}        225 {c |}{res}      1,256        0.19       82.17
{txt}      225.5 {c |}{res}      1,256        0.19       82.36
{txt}        226 {c |}{res}      1,256        0.19       82.56
{txt}      226.5 {c |}{res}      1,256        0.19       82.75
{txt}        227 {c |}{res}      1,256        0.19       82.95
{txt}      227.5 {c |}{res}      1,256        0.19       83.14
{txt}        228 {c |}{res}      1,256        0.19       83.33
{txt}      228.5 {c |}{res}      1,256        0.19       83.53
{txt}        229 {c |}{res}      1,256        0.19       83.72
{txt}      229.5 {c |}{res}      1,256        0.19       83.91
{txt}        230 {c |}{res}      1,256        0.19       84.11
{txt}      230.5 {c |}{res}      1,256        0.19       84.30
{txt}        231 {c |}{res}      1,256        0.19       84.50
{txt}      231.5 {c |}{res}      1,256        0.19       84.69
{txt}        232 {c |}{res}      1,256        0.19       84.88
{txt}      232.5 {c |}{res}      1,256        0.19       85.08
{txt}        233 {c |}{res}      1,256        0.19       85.27
{txt}      233.5 {c |}{res}      1,256        0.19       85.47
{txt}        234 {c |}{res}      1,256        0.19       85.66
{txt}      234.5 {c |}{res}      1,256        0.19       85.85
{txt}        235 {c |}{res}      1,256        0.19       86.05
{txt}      235.5 {c |}{res}      1,256        0.19       86.24
{txt}        236 {c |}{res}      1,256        0.19       86.43
{txt}      236.5 {c |}{res}      1,256        0.19       86.63
{txt}        237 {c |}{res}      1,256        0.19       86.82
{txt}      237.5 {c |}{res}      1,256        0.19       87.02
{txt}        238 {c |}{res}      1,256        0.19       87.21
{txt}      238.5 {c |}{res}      1,256        0.19       87.40
{txt}        239 {c |}{res}      1,256        0.19       87.60
{txt}      239.5 {c |}{res}      1,256        0.19       87.79
{txt}        240 {c |}{res}      1,256        0.19       87.98
{txt}      240.5 {c |}{res}      1,256        0.19       88.18
{txt}        241 {c |}{res}      1,256        0.19       88.37
{txt}      241.5 {c |}{res}      1,256        0.19       88.57
{txt}        242 {c |}{res}      1,256        0.19       88.76
{txt}      242.5 {c |}{res}      1,256        0.19       88.95
{txt}        243 {c |}{res}      1,256        0.19       89.15
{txt}      243.5 {c |}{res}      1,256        0.19       89.34
{txt}        244 {c |}{res}      1,256        0.19       89.53
{txt}      244.5 {c |}{res}      1,256        0.19       89.73
{txt}        245 {c |}{res}      1,256        0.19       89.92
{txt}      245.5 {c |}{res}      1,256        0.19       90.12
{txt}        246 {c |}{res}      1,256        0.19       90.31
{txt}      246.5 {c |}{res}      1,256        0.19       90.50
{txt}        247 {c |}{res}      1,256        0.19       90.70
{txt}      247.5 {c |}{res}      1,256        0.19       90.89
{txt}        248 {c |}{res}      1,256        0.19       91.09
{txt}      248.5 {c |}{res}      1,256        0.19       91.28
{txt}        249 {c |}{res}      1,256        0.19       91.47
{txt}      249.5 {c |}{res}      1,256        0.19       91.67
{txt}        250 {c |}{res}      1,256        0.19       91.86
{txt}      250.5 {c |}{res}      1,256        0.19       92.05
{txt}        251 {c |}{res}      1,256        0.19       92.25
{txt}      251.5 {c |}{res}      1,256        0.19       92.44
{txt}        252 {c |}{res}      1,256        0.19       92.64
{txt}      252.5 {c |}{res}      1,256        0.19       92.83
{txt}        253 {c |}{res}      1,256        0.19       93.02
{txt}      253.5 {c |}{res}      1,256        0.19       93.22
{txt}        254 {c |}{res}      1,256        0.19       93.41
{txt}      254.5 {c |}{res}      1,256        0.19       93.60
{txt}        255 {c |}{res}      1,256        0.19       93.80
{txt}      255.5 {c |}{res}      1,256        0.19       93.99
{txt}        256 {c |}{res}      1,256        0.19       94.19
{txt}      256.5 {c |}{res}      1,256        0.19       94.38
{txt}        257 {c |}{res}      1,256        0.19       94.57
{txt}      257.5 {c |}{res}      1,256        0.19       94.77
{txt}        258 {c |}{res}      1,256        0.19       94.96
{txt}      258.5 {c |}{res}      1,256        0.19       95.16
{txt}        259 {c |}{res}      1,256        0.19       95.35
{txt}      259.5 {c |}{res}      1,256        0.19       95.54
{txt}        260 {c |}{res}      1,256        0.19       95.74
{txt}      260.5 {c |}{res}      1,256        0.19       95.93
{txt}        261 {c |}{res}      1,256        0.19       96.12
{txt}      261.5 {c |}{res}      1,256        0.19       96.32
{txt}        262 {c |}{res}      1,256        0.19       96.51
{txt}      262.5 {c |}{res}      1,256        0.19       96.71
{txt}        263 {c |}{res}      1,256        0.19       96.90
{txt}      263.5 {c |}{res}      1,256        0.19       97.09
{txt}        264 {c |}{res}      1,256        0.19       97.29
{txt}      264.5 {c |}{res}      1,256        0.19       97.48
{txt}        265 {c |}{res}      1,256        0.19       97.67
{txt}      265.5 {c |}{res}      1,256        0.19       97.87
{txt}        266 {c |}{res}      1,256        0.19       98.06
{txt}      266.5 {c |}{res}      1,256        0.19       98.26
{txt}        267 {c |}{res}      1,256        0.19       98.45
{txt}      267.5 {c |}{res}      1,256        0.19       98.64
{txt}        268 {c |}{res}      1,256        0.19       98.84
{txt}      268.5 {c |}{res}      1,256        0.19       99.03
{txt}        269 {c |}{res}      1,256        0.19       99.22
{txt}      269.5 {c |}{res}      1,256        0.19       99.42
{txt}        270 {c |}{res}      1,256        0.19       99.61
{txt}      270.5 {c |}{res}      1,256        0.19       99.81
{txt}        271 {c |}{res}      1,256        0.19      100.00
{txt}{hline 12}{c +}{hline 35}
      Total {c |}{res}    648,096      100.00
{txt}
{com}. codebook e_bin // no more missings.  

{txt}{hline}
{res}e_bin{right:e(max integer)}
{txt}{hline}

{col 19}Type: Numeric ({res}float{txt})

{col 18}Range: [{res}59{txt},{res}1291{txt}]{col 55}Units: {res}1
{col 10}{txt}Unique values: {res}625{col 51}{txt}Missing .: {res}595,465{txt}/{res}648,096

{txt}{col 19}Mean: {res}{ralign 7:201.971}
{txt}{col 14}Std. dev.: {res}{ralign 7:84.7149}

{txt}{col 12}Percentiles: {col 25}{ralign 7:10%}{ralign 10:25%}{ralign 10:50%}{ralign 10:75%}{ralign 10:90%}
{res}{col 25}{ralign 7:151}{ralign 10:     167}{ralign 10:     183}{ralign 10:     211}{ralign 10:     263}
{txt}
{com}. 
.         ** define B (bunching) and R (restricted) 
. 
. gen restricted = 0 
{txt}
{com}. gen bunching = 0 
{txt}
{com}. 
.         ** bunching based on eei_bins 
. replace restricted = 1 if eei_bin >= 59 
{txt}(533,800 real changes made)

{com}. replace bunching = 1 if eei_bin < 59 & eei_bin >= 57 
{txt}(5,024 real changes made)

{com}. 
. 
. gen space = 0 // categorical variables for all product segments: 0 for U, 1 for R, 2 for B  
{txt}
{com}. replace space = 1 if restricted == 1 
{txt}(533,800 real changes made)

{com}. replace space = 2 if bunching == 1 
{txt}(5,024 real changes made)

{com}. 
.         ** align cell order to put bunching cells first for regression 
. gsort +year +month +ccode -space +eei_bin // sort order avoids problems in spatial matrix 
{txt}
{com}. by year month ccode: gen id_bin = _n // ordered list 
{txt}
{com}. tab id_bin if bunching == 1 

     {txt}id_bin {c |}      Freq.     Percent        Cum.
{hline 12}{c +}{hline 35}
          1 {c |}{res}      1,256       25.00       25.00
{txt}          2 {c |}{res}      1,256       25.00       50.00
{txt}          3 {c |}{res}      1,256       25.00       75.00
{txt}          4 {c |}{res}      1,256       25.00      100.00
{txt}{hline 12}{c +}{hline 35}
      Total {c |}{res}      5,024      100.00
{txt}
{com}. 
.         ** simplify labelling for outcomes 
. gen csd = cell_date_sales 
{txt}
{com}. gen ccd = cell_date_count
{txt}
{com}. gen csy = cell_year_sales 
{txt}(595,465 missing values generated)

{com}. gen ccy = cell_year_count
{txt}(595,465 missing values generated)

{com}. 
. **************************
. save bunching_2_collapse_1512, replace 
{txt}{p 0 4 2}
(file {bf}
bunching_2_collapse_1512.dta{rm}
not found)
{p_end}
{p 0 4 2}
file {bf}
bunching_2_collapse_1512.dta{rm}
saved
{p_end}

{com}. ****************************
. 
. log close 
      {txt}name:  {res}<unnamed>
       {txt}log:  {res}R:\WSV2\TBu_AKe\Bunching_NEW\Data\bunching_1_bins_2703.smcl
  {txt}log type:  {res}smcl
 {txt}closed on:  {res}11 Apr 2023, 18:13:20
{txt}{.-}
{smcl}
{txt}{sf}{ul off}